APPS.PAY_NO_SAL_STATISTICS_ARCHIVE dependencies on PAY_ACTION_INFORMATION

Line 283: pay_action_information_api.create_action_information (

279: FETCH csr_legal_employers INTO l_legal_employer_rec;
280: CLOSE csr_legal_employers;
281:
282:
283: pay_action_information_api.create_action_information (
284: p_action_information_id=> l_action_info_id,
285: p_action_context_id=> p_payroll_action_id,
286: p_action_context_type=> 'PA',
287: p_object_version_number=> l_ovn,

Line 334: pay_action_information_api.create_action_information (

330: OPEN csr_location(l_legal_employer_rec.location_id);
331: FETCH csr_location INTO l_location_rec;
332: CLOSE csr_location;
333: END IF;
334: pay_action_information_api.create_action_information (
335: p_action_information_id=> l_action_info_id,
336: p_action_context_id=> p_payroll_action_id,
337: p_action_context_type=> 'PA',
338: p_object_version_number=> l_ovn,

Line 386: pay_action_information_api.create_action_information (

382: FETCH csr_location INTO l_location_rec;
383: CLOSE csr_location;
384:
385:
386: pay_action_information_api.create_action_information (
387: p_action_information_id=> l_action_info_id,
388: p_action_context_id=> p_payroll_action_id,
389: p_action_context_type=> 'PA',
390: p_object_version_number=> l_ovn,

Line 739: pay_action_information_api.create_action_information (

735: OPEN csr_org_emp_defaults;
736: FETCH csr_org_emp_defaults INTO l_csr_org_emp_defaults_rec;
737: CLOSE csr_org_emp_defaults;
738:
739: pay_action_information_api.create_action_information (
740: p_action_information_id=> l_action_info_id,
741: p_action_context_id=> l_assact_id,
742: p_action_context_type=> 'AAP',
743: p_object_version_number=> l_ovn,

Line 902: pay_action_information_api.create_action_information (

898: null;
899: end;
900:
901:
902: pay_action_information_api.create_action_information (
903: p_action_information_id=> l_action_info_id,
904: p_action_context_id=> l_assact_id,
905: p_action_context_type=> 'AAP',
906: p_object_version_number=> l_ovn,

Line 1104: FROM pay_action_information pai

1100: IS
1101: SELECT fnd_date.canonical_to_date(action_information5) report_date,
1102: action_information6 version,
1103: nvl(action_information8,action_information4) name_sp
1104: FROM pay_action_information pai
1105: WHERE pai.action_context_id = p_payroll_action_id
1106: AND pai.action_context_type='PA'
1107: AND pai.action_information_category='EMEA REPORT DETAILS'
1108: AND pai.action_information1='PYNOSSTA';

Line 1122: FROM pay_action_information pai

1118: action_information5,
1119: action_information6,
1120: action_information7,
1121: action_information8
1122: FROM pay_action_information pai
1123: WHERE pai.action_context_id = p_payroll_action_id
1124: AND pai.action_context_type='PA'
1125: AND pai.action_information_category='EMEA REPORT INFORMATION'
1126: AND pai.action_information1='PYNOSSTA'

Line 1140: FROM pay_action_information pai

1136: action_information5,
1137: action_information6,
1138: action_information7,
1139: action_information8
1140: FROM pay_action_information pai
1141: WHERE pai.action_context_id = p_payroll_action_id
1142: AND pai.action_context_type='PA'
1143: AND pai.action_information_category='EMEA REPORT INFORMATION'
1144: AND pai.action_information1='PYNOSSTA'

Line 1183: pay_action_information pai,

1179: pai_sal.action_information19 SSB_CODE_0041_YTD
1180: FROM
1181: pay_payroll_actions paa,
1182: pay_assignment_actions assg,
1183: pay_action_information pai,
1184: pay_action_information pai_sal
1185: WHERE
1186: paa.payroll_action_id = p_payroll_action_id
1187: AND assg.payroll_action_id = paa.payroll_action_id

Line 1184: pay_action_information pai_sal

1180: FROM
1181: pay_payroll_actions paa,
1182: pay_assignment_actions assg,
1183: pay_action_information pai,
1184: pay_action_information pai_sal
1185: WHERE
1186: paa.payroll_action_id = p_payroll_action_id
1187: AND assg.payroll_action_id = paa.payroll_action_id
1188: AND pai.action_context_id= assg.assignment_action_id