APPS.PAY_MX_PAYROLL_ARCH dependencies on PAY_ACTION_INFORMATION

Line 954: FROM pay_action_information

950: effective_date effective_date,
951: action_information12 ytd_hours,
952: action_information15 ytd_days,
953: action_information16 attribute_name
954: FROM pay_action_information
955: WHERE action_information_category IN ('AC EARNINGS', 'AC DEDUCTIONS')
956: AND action_context_id = cp_xfr_action_id;
957:
958:

Line 970: pay_action_information pai

966: CURSOR c_last_per_xfr_run IS
967: SELECT pai.action_context_id
968: FROM per_assignments_f paf2,
969: per_assignments_f paf,
970: pay_action_information pai
971: WHERE paf.assignment_id = p_assignment_id
972: AND paf.effective_end_date >= trunc(p_pymt_eff_date, 'Y')
973: AND paf.effective_start_date <= p_pymt_eff_date
974: AND paf.person_id = paf2.person_id

Line 3082: FROM pay_action_information

3078: ,cp_assignment_id IN NUMBER) IS
3079: SELECT action_information_id, effective_date,
3080: object_version_number,
3081: tax_unit_id
3082: FROM pay_action_information
3083: WHERE action_context_id = cp_action_context_id
3084: AND action_context_type = 'AAP'
3085: AND assignment_id = cp_assignment_id
3086: AND action_information_category = 'EMPLOYEE DETAILS';

Line 3151: pay_action_information_api.update_action_information

3147: CLOSE c_get_employee_info;
3148:
3149: hr_utility.trace('lv_employee_name = *' || lv_employee_name ||'*');
3150:
3151: pay_action_information_api.update_action_information
3152: (p_action_information_id => ln_action_information_id
3153: ,p_object_version_number => ln_ovn
3154: ,p_action_information1 => lv_employee_name
3155: ,p_action_information2 => ln_legal_employer_id

Line 4251: -- insert rows in pay_action_information table

4247:
4248:
4249: hr_utility.set_location(gv_package || lv_procedure_name, 80);
4250:
4251: -- insert rows in pay_action_information table
4252: IF pay_emp_action_arch.ltr_ppa_arch.count > 0 THEN
4253: pay_emp_action_arch.insert_rows_thro_api_process(
4254: p_action_context_id => p_payroll_action_id
4255: ,p_action_context_type => 'PA'

Line 4795: FROM pay_action_information

4791: AND paa.assignment_action_id = cp_prepayment_action_id;
4792:
4793: CURSOR c_check_pay_action( cp_payroll_action_id IN NUMBER) IS
4794: SELECT count(*)
4795: FROM pay_action_information
4796: WHERE action_context_id = cp_payroll_action_id
4797: AND action_context_type = 'PA';
4798:
4799: CURSOR c_payment_info(cp_prepay_action_id NUMBER) IS