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 752: FROM pay_action_information

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

Line 770: UPDATE pay_action_information

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

Line 856: pay_action_information_api.create_action_information (

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

Line 907: pay_action_information_api.create_action_information (

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

Line 1119: FROM pay_action_information pai

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

Line 1140: pay_action_information pai

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