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_ZA_COIDA_ARCHIVE dependencies on PAY_ACTION_INFORMATION

Line 128: from pay_action_information pai

124: , fnd_date.canonical_to_date(pai.action_information12) split_end_date1
125: , fnd_date.canonical_to_date(pai.action_information13) split_start_date2
126: , fnd_date.canonical_to_date(pai.action_information14) split_end_date2
127: , pai.action_information7 num_of_days
128: from pay_action_information pai
129: where action_context_id = p_payroll_action_id
130: and action_information_category = 'ZA_COID_PAYROLL_INFO';
131:
132: begin

Line 325: pay_action_information_api.create_action_information

321: order by ass.person_id';
322:
323: hr_utility.set_location('Populating ZA_COID_PAYROLL_INFO',60);
324: -- Archive 'ZA_COID_PAYROLL_INFO'
325: pay_action_information_api.create_action_information
326: (
327: p_action_information_id => l_action_info_id,
328: p_action_context_id => pactid,
329: p_action_context_type => 'PA',

Line 498: pay_action_information_api.create_action_information

494: l_ovn number;
495: l_action_id number;
496: begin
497: hr_utility.set_location('Entering: '||l_proc,1);
498: pay_action_information_api.create_action_information
499: (
500: p_action_information_id => l_action_id,
501: p_action_context_id => p_action_context_id,
502: p_action_context_type => p_action_context_type,

Line 1193: , pay_action_information pai

1189: pai.action_information30 person_id
1190: , pai.action_information9 asg_type
1191: from pay_payroll_actions ppa
1192: , pay_assignment_actions paa
1193: , pay_action_information pai
1194: , pay_assignment_actions paa2
1195: , pay_action_information pai2
1196: where ppa.payroll_action_id = pactid
1197: and ppa.action_status = 'C'

Line 1195: , pay_action_information pai2

1191: from pay_payroll_actions ppa
1192: , pay_assignment_actions paa
1193: , pay_action_information pai
1194: , pay_assignment_actions paa2
1195: , pay_action_information pai2
1196: where ppa.payroll_action_id = pactid
1197: and ppa.action_status = 'C'
1198: and paa.payroll_action_id = ppa.payroll_action_id
1199: and paa.action_status = 'C'

Line 1214: from pay_action_information pai,

1210:
1211: --Retrieve the details of duplicate employee records
1212: cursor csr_dup_emp_action_info (l_person_id number, l_asg_type varchar2) is
1213: select pai.*
1214: from pay_action_information pai,
1215: pay_assignment_actions paa
1216: where pai.action_information30 = l_person_id
1217: and pai.action_information9 = l_asg_type
1218: and paa.payroll_action_id = pactid

Line 1225: from pay_action_information pai

1221:
1222: --Retrieve the details of duplicate employee income records
1223: cursor csr_dup_emp_inc_info (l_act_context number, l_month varchar2) is
1224: select pai.*
1225: from pay_action_information pai
1226: where pai.action_context_id = l_act_context
1227: and pai.action_information1 = nvl(l_month,pai.action_information1)
1228: and pai.action_information_category='ZA_COID_EMP_INCOME_INFO';
1229:

Line 1241: from pay_action_information pai

1237: , nvl(sum(pai.action_information5),0) tot_income
1238: , pai.action_information1 mon
1239: , fnd_date.canonical_to_date(pai.action_information10) pay_adv_date --revisit --need to populate this in archive code
1240: , pai.action_information8 num_days
1241: from pay_action_information pai
1242: , pay_assignment_actions paa
1243: , pay_action_information pai2
1244: where pai.action_information30 = l_person_id
1245: and pai.action_information9 = l_asg_type

Line 1243: , pay_action_information pai2

1239: , fnd_date.canonical_to_date(pai.action_information10) pay_adv_date --revisit --need to populate this in archive code
1240: , pai.action_information8 num_days
1241: from pay_action_information pai
1242: , pay_assignment_actions paa
1243: , pay_action_information pai2
1244: where pai.action_information30 = l_person_id
1245: and pai.action_information9 = l_asg_type
1246: and paa.assignment_action_id = pai.action_context_id
1247: and paa.payroll_action_id = pactid

Line 1270: from pay_action_information pai --ZA_COID_EMP_INFO

1266: , nvl(sum(pai2.action_information6),0) act_earn1
1267: , nvl(sum(pai2.action_information7),0) act_earn2
1268: , pai2.action_information1 mon
1269: , pai.action_information9 asg_type
1270: from pay_action_information pai --ZA_COID_EMP_INFO
1271: , pay_action_information pai2 --ZA_COID_EMP_INCOME_INFO
1272: , pay_assignment_actions paa
1273: where paa.payroll_action_id = pactid
1274: and paa.assignment_action_id = pai.action_context_id

Line 1271: , pay_action_information pai2 --ZA_COID_EMP_INCOME_INFO

1267: , nvl(sum(pai2.action_information7),0) act_earn2
1268: , pai2.action_information1 mon
1269: , pai.action_information9 asg_type
1270: from pay_action_information pai --ZA_COID_EMP_INFO
1271: , pay_action_information pai2 --ZA_COID_EMP_INCOME_INFO
1272: , pay_assignment_actions paa
1273: where paa.payroll_action_id = pactid
1274: and paa.assignment_action_id = pai.action_context_id
1275: and pai.action_information_category = 'ZA_COID_EMP_INFO'

Line 1293: from pay_action_information

1289: and time_period_id >= p_strt_prd_id
1290: and time_period_id <= p_end_prd_id
1291: minus
1292: select action_information1 mon
1293: from pay_action_information
1294: where action_context_id = pactid
1295: and action_information_category = 'ZA_COID_TOT_MONTH_INFO'
1296: and action_information9 = p_asg_type;
1297:

Line 1417: pay_action_information_api.update_action_information(

1413: );
1414:
1415: else
1416: --Update action info
1417: pay_action_information_api.update_action_information(
1418: p_action_information_id => rec_emp_inc_info.action_information_id,
1419: p_object_version_number => rec_emp_inc_info.object_version_number,
1420: p_action_information1 => l_month,
1421: p_action_information2 => cum_tab(l_month).norm_inc,

Line 1435: pay_action_information_api.update_action_information(

1431: l_month:=cum_tab.next(l_month);
1432: end loop;
1433: else --exclude other records
1434: --Update action info29 of 'ZA_COID_EMP_INFO' to 'E' i.e. Exclude
1435: pay_action_information_api.update_action_information(
1436: p_action_information_id => rec_action_info.action_information_id,
1437: p_object_version_number => rec_action_info.object_version_number,
1438: p_action_information29 => 'E'
1439: );

Line 1444: pay_action_information_api.update_action_information(

1440:
1441: for rec_dup_inc_info in csr_dup_emp_inc_info(l_act_id,null)
1442: loop
1443: --Update action info29 of 'ZA_COID_EMP_INCOME_INFO' to 'E' i.e. Exclude
1444: pay_action_information_api.update_action_information(
1445: p_action_information_id => rec_dup_inc_info.action_information_id,
1446: p_object_version_number => rec_dup_inc_info.object_version_number,
1447: p_action_information29 => 'E'
1448: );