APPS.PAY_SE_STAT_OFFICE_ARCHIVE dependencies on PAY_ACTION_INFORMATION

Line 230: pay_action_information_api.create_action_information (

226: FETCH csr_legal_employer_details INTO l_legal_employer_details_rec;
227: CLOSE csr_legal_employer_details;
228:
229:
230: pay_action_information_api.create_action_information (
231: p_action_information_id=> l_action_info_id,
232: p_action_context_id=> p_payroll_action_id,
233: p_action_context_type=> 'PA',
234: p_object_version_number=> l_ovn,

Line 281: pay_action_information_api.create_action_information (

277: OPEN csr_le_contact_person(g_legal_employer_id);
278: FETCH csr_le_contact_person INTO l_le_contact_person_rec;
279: CLOSE csr_le_contact_person;
280:
281: pay_action_information_api.create_action_information (
282: p_action_information_id=> l_action_info_id,
283: p_action_context_id=> p_payroll_action_id,
284: p_action_context_type=> 'PA',
285: p_object_version_number=> l_ovn,

Line 751: FROM pay_action_information

747: SELECT action_information8,
748: action_information10
749: INTO l_check_end_date,
750: l_check_days
751: FROM pay_action_information
752: WHERE action_context_id = l_assact_id
753: AND action_information13 = l_start_end_date.source_id;
754: /*
755: If more than one results exist for the same entry

Line 769: UPDATE pay_action_information

765: ,l_start_end_date.source_id);
766: FETCH csr_total_sickness_days INTO l_total_sickness_days_rec;
767: CLOSE csr_total_sickness_days;
768:
769: UPDATE pay_action_information
770: set action_information8 = fnd_date.date_to_canonical(greatest(l_sickness_end_date,fnd_date.canonical_to_date(l_check_end_date))),
771: action_information10 = least(l_total_sickness_days_rec.full_day,l_employer_days)
772: WHERE action_context_id = l_assact_id
773: AND action_information13 = l_start_end_date.source_id;

Line 855: pay_action_information_api.create_action_information (

851: ELSE
852: l_sickness_start_date := l_start_end_date.start_date;
853: END IF;
854:
855: pay_action_information_api.create_action_information (
856: p_action_information_id=> l_action_info_id,
857: p_action_context_id=> l_assact_id,
858: p_action_context_type=> 'AAP',
859: p_object_version_number=> l_ovn,

Line 906: pay_action_information_api.create_action_information (

902:
903: FOR l_csr_correction_data IN csr_correction_data (l_assignments_rec.assignment_id) LOOP
904:
905: IF l_csr_correction_data.start_date >= g_start_date and l_csr_correction_data.start_date <= g_end_date THEN
906: pay_action_information_api.create_action_information (
907: p_action_information_id=> l_action_info_id,
908: p_action_context_id=> l_assact_id,
909: p_action_context_type=> 'AAP',
910: p_object_version_number=> l_ovn,

Line 1118: FROM pay_action_information pai

1114: action_information7 postal_code,
1115: action_information8 country,
1116: action_information9 contact_person,
1117: effective_date
1118: FROM pay_action_information pai
1119: WHERE pai.action_context_id = p_payroll_action_id
1120: AND pai.action_context_type='PA'
1121: AND pai.action_information_category='EMEA REPORT INFORMATION'
1122: AND pai.action_information1='PYSESTOA'

Line 1139: pay_action_information pai

1135: pai.action_information12 correction
1136: FROM
1137: pay_payroll_actions paa,
1138: pay_assignment_actions assg,
1139: pay_action_information pai
1140: WHERE
1141: paa.payroll_action_id = p_payroll_action_id
1142: AND assg.payroll_action_id = paa.payroll_action_id
1143: AND pai.action_context_id= assg.assignment_action_id