APPS.PAY_US_PAYSLIP_SIMULATION_MAIN dependencies on PAY_PAYROLL_ACTIONS

Line 95: pay_payroll_actions ppa

91: CURSOR cur_reporting_level(cp_payroll_action_id NUMBER)
92: IS
93: SELECT org_information1
94: FROM hr_organization_information hoi,
95: pay_payroll_actions ppa
96: where ppa.payroll_action_id = cp_payroll_action_id
97: and hoi.organization_id = ppa.business_group_id
98: and hoi.org_information_context = 'Payroll Archiver Level';
99:

Line 183: pay_payroll_actions ppa

179: ppa.business_group_id,
180: ppa.effective_date,
181: ppa.date_earned
182: FROM pay_assignment_actions paa,
183: pay_payroll_actions ppa
184: WHERE paa.assignment_action_id = cp_source_action_id
185: AND ppa.payroll_action_id = paa.payroll_action_id;
186:
187: CURSOR get_legislation_code(cp_business_group_id NUMBER,

Line 2209: pay_payroll_actions ppa,

2205: cp_element_type_id NUMBER ) IS
2206: SELECT DISTINCT peef.element_entry_id
2207: FROM pay_element_entries_f peef,
2208: pay_assignment_actions paa,
2209: pay_payroll_actions ppa,
2210: per_time_periods ptp
2211: WHERE paa.assignment_action_id = cp_run_action_id
2212: AND ppa.payroll_action_id = paa.payroll_action_id
2213: AND ptp.payroll_id = ppa.payroll_id

Line 2317: pay_payroll_actions ppa,

2313: pet.element_information10,
2314: pet.element_information12,
2315: pet.processing_priority
2316: FROM pay_assignment_actions paa,
2317: pay_payroll_actions ppa,
2318: pay_all_payrolls_f ppf,
2319: pay_run_results prr,
2320: pay_element_types_f pet,
2321: pay_element_classifications pec,

Line 3300: pay_payroll_actions ppa,

3296: IS
3297: SELECT ptp.time_period_id,
3298: NVL(ppa.date_earned,ppa.effective_date)
3299: FROM pay_assignment_actions paa,
3300: pay_payroll_actions ppa,
3301: per_time_periods ptp
3302: WHERE paa.assignment_action_id = cp_run_assignment_action
3303: AND ppa.payroll_action_id = paa.payroll_action_id
3304: AND ptp.payroll_id = ppa.payroll_id

Line 3588: FROM pay_payroll_actions ppa

3584: ppa.consolidation_set_id,
3585: ppa.payroll_id,
3586: ppa.time_period_id,
3587: ppa.effective_date
3588: FROM pay_payroll_actions ppa
3589: WHERE payroll_action_id = cp_payroll_action_id;
3590:
3591: CURSOR c_get_legislation_code (cp_business_group NUMBER)
3592: IS

Line 3624: ln_business_group_id pay_payroll_actions.business_group_id%TYPE;

3620: paa.assignment_action_id;
3621:
3622: lv_procedure_name VARCHAR2(100) := '.archive_data';
3623:
3624: ln_business_group_id pay_payroll_actions.business_group_id%TYPE;
3625: ln_consolidation_set_id pay_payroll_actions.consolidation_set_id%TYPE;
3626: ln_payroll_id pay_payroll_actions.payroll_id%TYPE;
3627: ln_time_period_id pay_payroll_actions.time_period_id%TYPE;
3628: ld_effective_date DATE;

Line 3625: ln_consolidation_set_id pay_payroll_actions.consolidation_set_id%TYPE;

3621:
3622: lv_procedure_name VARCHAR2(100) := '.archive_data';
3623:
3624: ln_business_group_id pay_payroll_actions.business_group_id%TYPE;
3625: ln_consolidation_set_id pay_payroll_actions.consolidation_set_id%TYPE;
3626: ln_payroll_id pay_payroll_actions.payroll_id%TYPE;
3627: ln_time_period_id pay_payroll_actions.time_period_id%TYPE;
3628: ld_effective_date DATE;
3629:

Line 3626: ln_payroll_id pay_payroll_actions.payroll_id%TYPE;

3622: lv_procedure_name VARCHAR2(100) := '.archive_data';
3623:
3624: ln_business_group_id pay_payroll_actions.business_group_id%TYPE;
3625: ln_consolidation_set_id pay_payroll_actions.consolidation_set_id%TYPE;
3626: ln_payroll_id pay_payroll_actions.payroll_id%TYPE;
3627: ln_time_period_id pay_payroll_actions.time_period_id%TYPE;
3628: ld_effective_date DATE;
3629:
3630: lv_payroll_multiple_asgs VARCHAR2(2);

Line 3627: ln_time_period_id pay_payroll_actions.time_period_id%TYPE;

3623:
3624: ln_business_group_id pay_payroll_actions.business_group_id%TYPE;
3625: ln_consolidation_set_id pay_payroll_actions.consolidation_set_id%TYPE;
3626: ln_payroll_id pay_payroll_actions.payroll_id%TYPE;
3627: ln_time_period_id pay_payroll_actions.time_period_id%TYPE;
3628: ld_effective_date DATE;
3629:
3630: lv_payroll_multiple_asgs VARCHAR2(2);
3631: