eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_FR_DADS_F_PKG dependencies on PAY_ACTION_INFORMATION

Line 146: from pay_action_information

142:
143: -- Cursor for fetching the payroll action
144: Cursor csr_payroll_action is
145: Select action_context_id
146: from pay_action_information
147: where action_context_type = 'PA'
148: and action_information_category = 'FR_DADS_FILE_DATA'
149: and action_information1 = 'S10.G01.00.004'
150: and action_information4 = p_dads_reference;

Line 159: from pay_action_information

155: hr_general.decode_lookup ('FR_DADS_RUBRICS',action_information1) rubric_meaning,
156: action_information4 file_value,
157: action_information5 user_value,
158: action_information9 usage
159: from pay_action_information
160: where action_context_id = c_payroll_action_id
161: and action_context_type = 'PA'
162: and action_information_category = 'FR_DADS_FILE_DATA'
163: and action_information1 like 'S10%'

Line 172: from pay_action_information

168: -- sorted alphabetically by company name
169: Cursor csr_count_comp(c_payroll_action_id number) is
170: Select distinct action_information3 company_id,
171: action_information4 comp_name
172: from pay_action_information
173: where action_information1 = 'S20.G01.00.002'
174: and action_context_id = c_payroll_action_id
175: and action_information_category = 'FR_DADS_FILE_DATA'
176: and action_context_type = 'PA'

Line 188: from pay_action_information

184: action_information4 file_value,
185: action_information5 user_value,
186: action_information7 extra_info,
187: action_information9 usage
188: from pay_action_information
189: where action_context_id = c_payroll_action_id
190: and action_context_type = 'PA'
191: and action_information_category = 'FR_DADS_FILE_DATA'
192: and action_information1 like 'S20%'

Line 204: from pay_action_information

200: hr_general.decode_lookup ('FR_DADS_RUBRICS',action_information1) rubric_meaning,
201: action_information4 file_value,
202: action_information5 user_value,
203: action_information9 usage
204: from pay_action_information
205: where action_context_id = c_asg_action_id
206: and action_context_type = 'AAP'
207: and action_information_category = 'FR_DADS_FILE_DATA'
208: and action_information1 like 'S30%'

Line 217: from pay_action_information

213: -- for each S30 record
214: Cursor csr_count_s41(c_asg_action_id number,
215: c_company_id number) is
216: Select distinct action_information8 ID2
217: from pay_action_information
218: where action_context_id = c_asg_action_id
219: and action_context_type = 'AAP'
220: and action_information_category = 'FR_DADS_FILE_DATA'
221: and action_information1 like 'S41%'

Line 234: from pay_action_information

230: hr_general.decode_lookup ('FR_DADS_RUBRICS',action_information1) rubric_meaning,
231: action_information4 file_value,
232: action_information5 user_value,
233: action_information9 usage
234: from pay_action_information
235: where action_context_id = c_asg_action_id
236: and action_context_type = 'AAP'
237: and action_information_category = 'FR_DADS_FILE_DATA'
238: and action_information1 like 'S41%'

Line 246: from pay_action_information

242: --
243: -- Cursor to fetch number of INSEE establishments
244: Cursor csr_count_s80(c_payroll_action_id number) is
245: select distinct action_information3 estab_id
246: from pay_action_information
247: where action_context_id = c_payroll_action_id
248: and action_context_type = 'PA'
249: and action_information_category = 'FR_DADS_FILE_DATA'
250: and action_information1 like 'S80%';

Line 260: from pay_action_information

256: hr_general.decode_lookup ('FR_DADS_RUBRICS',action_information1) rubric_meaning,
257: action_information4 file_value,
258: action_information5 user_value,
259: action_information9 usage
260: from pay_action_information
261: where action_context_id = c_payroll_action_id
262: and action_context_type = 'PA'
263: and action_information_category = 'FR_DADS_FILE_DATA'
264: and action_information1 like 'S80%'

Line 275: from pay_action_information

271: hr_general.decode_lookup ('FR_DADS_RUBRICS',action_information1) rubric_meaning,
272: action_information4 file_value,
273: action_information5 user_value,
274: action_information9 usage
275: from pay_action_information
276: where action_context_id = c_payroll_action_id
277: and action_context_type = 'PA'
278: and action_information_category = 'FR_DADS_FILE_DATA'
279: and action_information1 like 'S90%'

Line 286: from pay_action_information issue,

282: -- Cursor for S10 header
283: Cursor csr_s10_header_data(c_payroll_action_id number) is
284: Select issue.action_information4 issue_estab,
285: cre.action_information5 cre_estab_name
286: from pay_action_information issue,
287: pay_action_information cre
288: where issue.action_context_id = c_payroll_action_id
289: and issue.action_context_type = 'PA'
290: and issue.action_information_category = 'FR_DADS_FILE_DATA'

Line 287: pay_action_information cre

283: Cursor csr_s10_header_data(c_payroll_action_id number) is
284: Select issue.action_information4 issue_estab,
285: cre.action_information5 cre_estab_name
286: from pay_action_information issue,
287: pay_action_information cre
288: where issue.action_context_id = c_payroll_action_id
289: and issue.action_context_type = 'PA'
290: and issue.action_information_category = 'FR_DADS_FILE_DATA'
291: and issue.action_information1 = 'S10.G01.00.002'

Line 306: from pay_action_information comp,

302: Select comp.action_information4 comp_name,
303: nvl(cre_s20.action_information5,null) cre_name,
304: nvl(hq.action_information7,null) hq_name,
305: nvl(fisc.action_information4,null) fisc_name
306: from pay_action_information comp,
307: pay_action_information cre_s20,
308: pay_action_information hq,
309: pay_action_information fisc
310: where comp.action_context_id = c_payroll_action_id

Line 307: pay_action_information cre_s20,

303: nvl(cre_s20.action_information5,null) cre_name,
304: nvl(hq.action_information7,null) hq_name,
305: nvl(fisc.action_information4,null) fisc_name
306: from pay_action_information comp,
307: pay_action_information cre_s20,
308: pay_action_information hq,
309: pay_action_information fisc
310: where comp.action_context_id = c_payroll_action_id
311: and comp.action_context_type = 'PA'

Line 308: pay_action_information hq,

304: nvl(hq.action_information7,null) hq_name,
305: nvl(fisc.action_information4,null) fisc_name
306: from pay_action_information comp,
307: pay_action_information cre_s20,
308: pay_action_information hq,
309: pay_action_information fisc
310: where comp.action_context_id = c_payroll_action_id
311: and comp.action_context_type = 'PA'
312: and comp.action_information_category = 'FR_DADS_FILE_DATA'

Line 309: pay_action_information fisc

305: nvl(fisc.action_information4,null) fisc_name
306: from pay_action_information comp,
307: pay_action_information cre_s20,
308: pay_action_information hq,
309: pay_action_information fisc
310: where comp.action_context_id = c_payroll_action_id
311: and comp.action_context_type = 'PA'
312: and comp.action_information_category = 'FR_DADS_FILE_DATA'
313: and comp.action_information1 = 'S20.G01.00.002'

Line 341: from pay_action_information title,

337: Select nvl(title.action_information5,null) emp_title,
338: nvl(title.action_information8 ,null) emp_number,
339: nvl(first_name.action_information4,null) emp_first,
340: nvl(last_name.action_information4,null) emp_last
341: from pay_action_information title,
342: pay_action_information first_name,
343: pay_action_information last_name
344: where title.action_context_id = c_asg_action_id
345: and title.action_context_type = 'AAP'

Line 342: pay_action_information first_name,

338: nvl(title.action_information8 ,null) emp_number,
339: nvl(first_name.action_information4,null) emp_first,
340: nvl(last_name.action_information4,null) emp_last
341: from pay_action_information title,
342: pay_action_information first_name,
343: pay_action_information last_name
344: where title.action_context_id = c_asg_action_id
345: and title.action_context_type = 'AAP'
346: and title.action_information_category = 'FR_DADS_FILE_DATA'

Line 343: pay_action_information last_name

339: nvl(first_name.action_information4,null) emp_first,
340: nvl(last_name.action_information4,null) emp_last
341: from pay_action_information title,
342: pay_action_information first_name,
343: pay_action_information last_name
344: where title.action_context_id = c_asg_action_id
345: and title.action_context_type = 'AAP'
346: and title.action_information_category = 'FR_DADS_FILE_DATA'
347: and title.action_information1 = 'S30.G01.00.007'

Line 369: from pay_action_information estab,

365: c_s41_id2 number) is
366: Select hou_tl_estab.name emp_estab,
367: start_period.action_information4 period_start,
368: end_period.action_information4 period_end
369: from pay_action_information estab,
370: pay_action_information start_period,
371: pay_action_information end_period,
372: hr_all_organization_units_tl hou_tl_estab
373: where estab.action_context_id = c_asg_action_id

Line 370: pay_action_information start_period,

366: Select hou_tl_estab.name emp_estab,
367: start_period.action_information4 period_start,
368: end_period.action_information4 period_end
369: from pay_action_information estab,
370: pay_action_information start_period,
371: pay_action_information end_period,
372: hr_all_organization_units_tl hou_tl_estab
373: where estab.action_context_id = c_asg_action_id
374: and estab.action_context_type = 'AAP'

Line 371: pay_action_information end_period,

367: start_period.action_information4 period_start,
368: end_period.action_information4 period_end
369: from pay_action_information estab,
370: pay_action_information start_period,
371: pay_action_information end_period,
372: hr_all_organization_units_tl hou_tl_estab
373: where estab.action_context_id = c_asg_action_id
374: and estab.action_context_type = 'AAP'
375: and estab.action_information_category = 'FR_DADS_FILE_DATA'

Line 400: from pay_action_information

396: -- Cursor for S80 header
397: Cursor csr_s80_header_data(c_payroll_action_id number,
398: c_estab_id number)is
399: Select action_information4 estab_name
400: from pay_action_information
401: where action_context_id = c_payroll_action_id
402: and action_context_type = 'PA'
403: and action_information_category = 'FR_DADS_FILE_DATA'
404: and action_information1 = 'S80.G01.00.002'

Line 616: pay_action_information pacinfo_1';

612: AND (P_REPORT_INCLUSIONS= 'EMP' OR P_REPORT_INCLUSIONS= 'ALL') THEN
613: -- build up the query conditionally
614: l_s30_select := 'Select pasac.assignment_action_id
615: from pay_assignment_actions pasac,
616: pay_action_information pacinfo_1';
617: l_s30_where :=' where pasac.payroll_action_id = '||l_payroll_action_id||'
618: and pacinfo_1.action_context_id = pasac.assignment_action_id
619: and pacinfo_1.action_context_type =''AAP''
620: and pacinfo_1.action_information1 = '|| '''' ||l_sort_rubric1|| ''''||'

Line 624: l_s30_cond_from := ' ,pay_action_information pacinfo_2';

620: and pacinfo_1.action_information1 = '|| '''' ||l_sort_rubric1|| ''''||'
621: and pacinfo_1.action_information3 = '||comp_rec.company_id||'';
622: -- As p_sort_order_2 is not a mandatory parameter
623: IF p_sort_order_2 IS NOT NULL THEN
624: l_s30_cond_from := ' ,pay_action_information pacinfo_2';
625: l_s30_cond_where := 'and pacinfo_2.action_context_id = pasac.assignment_action_id
626: and pacinfo_2.action_context_type =''AAP''
627: and pacinfo_2.action_information1 = '|| '''' ||l_sort_rubric2|| ''''||'
628: and pacinfo_2.action_information3 = '||comp_rec.company_id||'';

Line 906: from pay_action_information

902: --
903: -- Cursor for fetching the payroll action
904: Cursor csr_payroll_action is
905: Select action_context_id
906: from pay_action_information
907: where action_context_type = 'PA'
908: and action_information_category = 'FR_DADS_FILE_DATA'
909: and action_information1 = 'S10.G01.00.004'
910: and action_information4 = p_dads_reference;

Line 917: from pay_action_information

913: Cursor csr_get_S10_rec(c_payroll_action_id number) IS
914: Select action_information1 rubric_code,
915: action_information2 error_warning,
916: action_information6 error_warning_message
917: from pay_action_information
918: where action_context_id = c_payroll_action_id
919: and action_context_type = 'PA'
920: and action_information_category = 'FR_DADS_FILE_DATA'
921: and action_information1 like 'S10%'

Line 931: from pay_action_information

927: -- sorted alphabetically by company name
928: Cursor csr_count_comp(c_payroll_action_id number) is
929: Select distinct action_information3 company_id,
930: action_information4 comp_name
931: from pay_action_information
932: where action_information1 = 'S20.G01.00.002'
933: and action_context_id = c_payroll_action_id
934: and action_information_category = 'FR_DADS_FILE_DATA'
935: and action_context_type = 'PA'

Line 944: from pay_action_information

940: c_company_id number)is
941: Select action_information1 rubric_code,
942: action_information2 error_warning,
943: action_information6 error_warning_message
944: from pay_action_information
945: where action_context_id = c_payroll_action_id
946: and action_context_type = 'PA'
947: and action_information_category = 'FR_DADS_FILE_DATA'
948: and action_information1 like 'S20%'

Line 959: from pay_action_information

955: c_company_id number)is
956: Select action_information1 rubric_code,
957: action_information2 error_warning,
958: action_information6 error_warning_message
959: from pay_action_information
960: where action_context_id = c_asg_action_id
961: and action_context_type = 'AAP'
962: and action_information_category = 'FR_DADS_FILE_DATA'
963: and action_information1 like 'S30%'

Line 973: from pay_action_information

969: -- for each S30 record
970: Cursor csr_count_s41(c_asg_action_id number,
971: c_company_id number) is
972: Select distinct action_information8 ID2
973: from pay_action_information
974: where action_context_id = c_asg_action_id
975: and action_context_type = 'AAP'
976: and action_information_category = 'FR_DADS_FILE_DATA'
977: and action_information1 like 'S41%'

Line 988: from pay_action_information

984: c_s41_id2 number) is
985: Select action_information1 rubric_code,
986: action_information2 error_warning,
987: action_information6 error_warning_message
988: from pay_action_information
989: where action_context_id = c_asg_action_id
990: and action_context_type = 'AAP'
991: and action_information_category = 'FR_DADS_FILE_DATA'
992: and action_information1 like 'S41%'

Line 1000: from pay_action_information

996: order by action_information1;
997: -- Cursor to fetch number of INSEE establishments
998: Cursor csr_count_s80(c_payroll_action_id number) is
999: select distinct action_information3 estab_id
1000: from pay_action_information
1001: where action_context_id = c_payroll_action_id
1002: and action_context_type = 'PA'
1003: and action_information_category = 'FR_DADS_FILE_DATA'
1004: and action_information1 like 'S80%';

Line 1012: from pay_action_information

1008: c_estab_id number)is
1009: Select action_information1 rubric_code,
1010: action_information2 error_warning,
1011: action_information6 error_warning_message
1012: from pay_action_information
1013: where action_context_id = c_payroll_action_id
1014: and action_context_type = 'PA'
1015: and action_information_category = 'FR_DADS_FILE_DATA'
1016: and action_information1 like 'S80%'

Line 1026: from pay_action_information

1022: Cursor csr_get_s90_data(c_payroll_action_id number)is
1023: Select action_information1 rubric_code,
1024: action_information2 error_warning,
1025: action_information6 error_warning_message
1026: from pay_action_information
1027: where action_context_id = c_payroll_action_id
1028: and action_context_type = 'PA'
1029: and action_information_category = 'FR_DADS_FILE_DATA'
1030: and action_information1 like 'S90%'

Line 1038: from pay_action_information issue,

1034: -- Cursor for S10 header
1035: Cursor csr_s10_header_data(c_payroll_action_id number) is
1036: Select issue.action_information4 issue_estab,
1037: cre.action_information5 cre_estab_name
1038: from pay_action_information issue,
1039: pay_action_information cre
1040: where issue.action_context_id = c_payroll_action_id
1041: and issue.action_context_type = 'PA'
1042: and issue.action_information_category = 'FR_DADS_FILE_DATA'

Line 1039: pay_action_information cre

1035: Cursor csr_s10_header_data(c_payroll_action_id number) is
1036: Select issue.action_information4 issue_estab,
1037: cre.action_information5 cre_estab_name
1038: from pay_action_information issue,
1039: pay_action_information cre
1040: where issue.action_context_id = c_payroll_action_id
1041: and issue.action_context_type = 'PA'
1042: and issue.action_information_category = 'FR_DADS_FILE_DATA'
1043: and issue.action_information1 = 'S10.G01.00.002'

Line 1058: from pay_action_information comp,

1054: Select comp.action_information4 comp_name,
1055: nvl(cre_s20.action_information5,null) cre_name,
1056: nvl(hq.action_information7,null) hq_name,
1057: nvl(fisc.action_information4,null) fisc_name
1058: from pay_action_information comp,
1059: pay_action_information cre_s20,
1060: pay_action_information hq,
1061: pay_action_information fisc
1062: where comp.action_context_id = c_payroll_action_id

Line 1059: pay_action_information cre_s20,

1055: nvl(cre_s20.action_information5,null) cre_name,
1056: nvl(hq.action_information7,null) hq_name,
1057: nvl(fisc.action_information4,null) fisc_name
1058: from pay_action_information comp,
1059: pay_action_information cre_s20,
1060: pay_action_information hq,
1061: pay_action_information fisc
1062: where comp.action_context_id = c_payroll_action_id
1063: and comp.action_context_type = 'PA'

Line 1060: pay_action_information hq,

1056: nvl(hq.action_information7,null) hq_name,
1057: nvl(fisc.action_information4,null) fisc_name
1058: from pay_action_information comp,
1059: pay_action_information cre_s20,
1060: pay_action_information hq,
1061: pay_action_information fisc
1062: where comp.action_context_id = c_payroll_action_id
1063: and comp.action_context_type = 'PA'
1064: and comp.action_information_category = 'FR_DADS_FILE_DATA'

Line 1061: pay_action_information fisc

1057: nvl(fisc.action_information4,null) fisc_name
1058: from pay_action_information comp,
1059: pay_action_information cre_s20,
1060: pay_action_information hq,
1061: pay_action_information fisc
1062: where comp.action_context_id = c_payroll_action_id
1063: and comp.action_context_type = 'PA'
1064: and comp.action_information_category = 'FR_DADS_FILE_DATA'
1065: and comp.action_information1 = 'S20.G01.00.002'

Line 1093: from pay_action_information title,

1089: Select nvl(title.action_information5,null) emp_title,
1090: nvl(title.action_information8 ,null) emp_number,
1091: nvl(first_name.action_information4,null) emp_first,
1092: nvl(last_name.action_information4,null) emp_last
1093: from pay_action_information title,
1094: pay_action_information first_name,
1095: pay_action_information last_name
1096: where title.action_context_id = c_asg_action_id
1097: and title.action_context_type = 'AAP'

Line 1094: pay_action_information first_name,

1090: nvl(title.action_information8 ,null) emp_number,
1091: nvl(first_name.action_information4,null) emp_first,
1092: nvl(last_name.action_information4,null) emp_last
1093: from pay_action_information title,
1094: pay_action_information first_name,
1095: pay_action_information last_name
1096: where title.action_context_id = c_asg_action_id
1097: and title.action_context_type = 'AAP'
1098: and title.action_information_category = 'FR_DADS_FILE_DATA'

Line 1095: pay_action_information last_name

1091: nvl(first_name.action_information4,null) emp_first,
1092: nvl(last_name.action_information4,null) emp_last
1093: from pay_action_information title,
1094: pay_action_information first_name,
1095: pay_action_information last_name
1096: where title.action_context_id = c_asg_action_id
1097: and title.action_context_type = 'AAP'
1098: and title.action_information_category = 'FR_DADS_FILE_DATA'
1099: and title.action_information1 = 'S30.G01.00.007'

Line 1121: from pay_action_information estab,

1117: c_s41_id2 number) is
1118: Select hou_tl_estab.name emp_estab,
1119: start_period.action_information4 period_start,
1120: end_period.action_information4 period_end
1121: from pay_action_information estab,
1122: pay_action_information start_period,
1123: pay_action_information end_period,
1124: hr_all_organization_units_tl hou_tl_estab
1125: where estab.action_context_id = c_asg_action_id

Line 1122: pay_action_information start_period,

1118: Select hou_tl_estab.name emp_estab,
1119: start_period.action_information4 period_start,
1120: end_period.action_information4 period_end
1121: from pay_action_information estab,
1122: pay_action_information start_period,
1123: pay_action_information end_period,
1124: hr_all_organization_units_tl hou_tl_estab
1125: where estab.action_context_id = c_asg_action_id
1126: and estab.action_context_type = 'AAP'

Line 1123: pay_action_information end_period,

1119: start_period.action_information4 period_start,
1120: end_period.action_information4 period_end
1121: from pay_action_information estab,
1122: pay_action_information start_period,
1123: pay_action_information end_period,
1124: hr_all_organization_units_tl hou_tl_estab
1125: where estab.action_context_id = c_asg_action_id
1126: and estab.action_context_type = 'AAP'
1127: and estab.action_information_category = 'FR_DADS_FILE_DATA'

Line 1152: from pay_action_information

1148: -- Cursor for S80 header
1149: Cursor csr_s80_header_data(c_payroll_action_id number,
1150: c_estab_id number)is
1151: Select action_information4 estab_name
1152: from pay_action_information
1153: where action_context_id = c_payroll_action_id
1154: and action_context_type = 'PA'
1155: and action_information_category = 'FR_DADS_FILE_DATA'
1156: and action_information1 = 'S80.G01.00.002'

Line 1330: pay_action_information pacinfo_1';

1326: AND (P_REPORT_INCLUSIONS= 'EMP' OR P_REPORT_INCLUSIONS= 'ALL') THEN
1327: -- build up the query conditionally
1328: l_s30_select := 'Select pasac.assignment_action_id
1329: from pay_assignment_actions pasac,
1330: pay_action_information pacinfo_1';
1331: l_s30_where :=' where pasac.payroll_action_id = '||l_payroll_action_id||'
1332: and pacinfo_1.action_context_id = pasac.assignment_action_id
1333: and pacinfo_1.action_context_type =''AAP''
1334: and pacinfo_1.action_information1 = '|| '''' ||l_sort_rubric1|| ''''||'

Line 1338: l_s30_cond_from := ' ,pay_action_information pacinfo_2';

1334: and pacinfo_1.action_information1 = '|| '''' ||l_sort_rubric1|| ''''||'
1335: and pacinfo_1.action_information3 = '||comp_rec.company_id||'';
1336: -- As p_sort_order_2 is not a mandatory parameter
1337: IF p_sort_order_2 IS NOT NULL THEN
1338: l_s30_cond_from := ' ,pay_action_information pacinfo_2';
1339: l_s30_cond_where := 'and pacinfo_2.action_context_id = pasac.assignment_action_id
1340: and pacinfo_2.action_context_type =''AAP''
1341: and pacinfo_2.action_information1 = '|| '''' ||l_sort_rubric2|| ''''||'
1342: and pacinfo_2.action_information3 = '||comp_rec.company_id||'';