APPS.PAY_US_ACTION_ARCH dependencies on PAY_ACTION_INFORMATION

Line 24: Employer Balances in pay_action_information table.

20: Name : pay_us_action_arch
21:
22: Description : This procedure is used by the External Process
23: Archive process to archive the Employee and
24: Employer Balances in pay_action_information table.
25:
26: Change List
27: -----------
28: Date Name Vers Bug No Description

Line 5856: from pay_action_information

5852: cursor c_get_archive_info(cp_action_context_id in number
5853: ,cp_assignment_id in number) is
5854: select action_information_id, effective_date,
5855: object_version_number
5856: from pay_action_information
5857: where action_context_id = cp_action_context_id
5858: and action_context_type = 'AAP'
5859: and assignment_id = cp_assignment_id
5860: and action_information_category = 'EMPLOYEE DETAILS';

Line 5909: pay_action_information_api.update_action_information

5905: close c_get_employee_info;
5906:
5907: hr_utility.trace('lv_employee_name = *' || lv_employee_name ||'*');
5908:
5909: pay_action_information_api.update_action_information
5910: (p_action_information_id => ln_action_information_id
5911: ,p_object_version_number => ln_ovn
5912: ,p_action_information1 => lv_employee_name
5913: );

Line 7698: from pay_action_information

7694: and paa.assignment_action_id = cp_prepayment_action_id;
7695:
7696: cursor c_check_pay_action( cp_payroll_action_id in number) is
7697: select count(*)
7698: from pay_action_information
7699: where action_context_id = cp_payroll_action_id
7700: and action_context_type = 'PA';
7701:
7702: cursor c_payment_info(cp_prepay_action_id number) is

Line 7767: from pay_action_information pai

7763: and ppa.payroll_id = cp_payroll_id
7764: and paf1.payroll_id = cp_payroll_id -- #9242223
7765: and ppa.action_type in ('Q', 'R', 'I','B')
7766: and not exists (select 'x'
7767: from pay_action_information pai
7768: where pai.action_context_id = cp_xfr_action_id
7769: and pai.assignment_id = paf1.assignment_id)
7770: and not exists (select 1
7771: from pay_payment_information_v ppi

Line 7784: from pay_action_information pai

7780: cursor c_prev_run_information(cp_assignment_id in number
7781: ,cp_xfr_action_id in number
7782: ,cp_effective_date in date) is
7783: select max(pai.effective_date)
7784: from pay_action_information pai
7785: where pai.action_context_type = 'AAP'
7786: and pai.assignment_id = cp_assignment_id
7787: and pai.action_information_category in ('AC EARNINGS', 'AC DEDUCTIONS')
7788: and pai.action_context_id <> cp_xfr_action_id