eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_US_PAYSLIP_SIMULATION_MAIN dependencies on PAY_ASSIGNMENT_ACTIONS

Line 182: FROM pay_assignment_actions paa,

178: SELECT paa.assignment_id,
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:

Line 2208: pay_assignment_actions paa,

2204: cp_assignment_id NUMBER ,
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

Line 2316: FROM pay_assignment_actions paa,

2312: ,4,'0')))), '00-000-0000') jurisdiction_code,
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,

Line 2395: FROM pay_assignment_actions paa

2391: ,4,'0')))), '00-000-0000') jurisdiction_code,
2392: pet.element_information10,
2393: pet.element_information12,
2394: pet.processing_priority
2395: FROM pay_assignment_actions paa
2396: ,pay_element_classifications pec
2397: ,pay_element_types_f pet
2398: ,pay_balance_types pbt
2399: ,pay_defined_balances pdb

Line 2893: pay_assignment_actions paa,

2889: pai.action_information11 taxable_benefits,
2890: pai.action_information12 alien_expat_earnings,
2891: pai.action_information13 non_payroll_payments
2892: FROM pay_emp_payslip_action_info_v payslipv,
2893: pay_assignment_actions paa,
2894: pay_action_information pai,
2895: fnd_sessions fs
2896: WHERE paa.assignment_id = cp_assignment_id
2897: AND payslipv.person_id = cp_person_id

Line 3289: FROM pay_assignment_actions paa

3285: cp_payroll_action_id NUMBER,
3286: cp_assignment_id NUMBER)
3287: IS
3288: SELECT paa.assignment_action_id
3289: FROM pay_assignment_actions paa
3290: WHERE paa.source_action_id = cp_source_action_id
3291: AND paa.assignment_id = cp_assignment_id
3292: AND paa.payroll_action_id = cp_payroll_action_id
3293: ORDER BY paa.assignment_action_id DESC;

Line 3299: FROM pay_assignment_actions paa,

3295: CURSOR c_time_period(cp_run_assignment_action NUMBER)
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

Line 3310: ln_ytd_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;

3306: BETWEEN ptp.start_date AND ptp.end_date;
3307:
3308: lv_procedure_name VARCHAR2(100) := '.process_actions';
3309:
3310: ln_ytd_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;
3311:
3312: lv_res_jurisdiction_code VARCHAR2(30);
3313:
3314: ln_time_period_id per_time_periods.time_period_id%TYPE;

Line 3578: FROM pay_assignment_actions

3574: CURSOR c_get_action_info(cp_assignment_action_id NUMBER)
3575: IS
3576: SELECT assignment_id,
3577: payroll_action_id
3578: FROM pay_assignment_actions
3579: WHERE assignment_action_id = cp_assignment_action_id;
3580:
3581: CURSOR c_get_payroll_action_info(cp_payroll_action_id NUMBER)
3582: IS

Line 3606: (cp_master_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)

3602: archived along with the corresponding Regular/Supplemental Run. Only
3603: for Separate Check Runs we need to archive data independently*/
3604:
3605: CURSOR c_get_assignment_actions
3606: (cp_master_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
3607: IS
3608: SELECT paa.assignment_action_id,
3609: paa.assignment_id,
3610: paa.tax_unit_id,

Line 3612: FROM pay_assignment_actions paa,

3608: SELECT paa.assignment_action_id,
3609: paa.assignment_id,
3610: paa.tax_unit_id,
3611: paa.payroll_action_id
3612: FROM pay_assignment_actions paa,
3613: pay_run_types_f prt
3614: WHERE paa.source_action_id = cp_master_assignment_action_id
3615: AND paa.run_type_id = prt.run_type_id
3616: AND paa.action_status = 'C'

Line 3634: ln_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;

3630: lv_payroll_multiple_asgs VARCHAR2(2);
3631:
3632: lv_legislation_code VARCHAR2(10);
3633:
3634: ln_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
3635: ln_assignment_id pay_assignment_actions.assignment_id%TYPE;
3636: ln_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
3637: ln_payroll_action_id pay_assignment_actions.payroll_action_id%TYPE;
3638:

Line 3635: ln_assignment_id pay_assignment_actions.assignment_id%TYPE;

3631:
3632: lv_legislation_code VARCHAR2(10);
3633:
3634: ln_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
3635: ln_assignment_id pay_assignment_actions.assignment_id%TYPE;
3636: ln_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
3637: ln_payroll_action_id pay_assignment_actions.payroll_action_id%TYPE;
3638:
3639: lv_gross_balance pay_balance_types.balance_name%TYPE;

Line 3636: ln_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;

3632: lv_legislation_code VARCHAR2(10);
3633:
3634: ln_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
3635: ln_assignment_id pay_assignment_actions.assignment_id%TYPE;
3636: ln_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
3637: ln_payroll_action_id pay_assignment_actions.payroll_action_id%TYPE;
3638:
3639: lv_gross_balance pay_balance_types.balance_name%TYPE;
3640: lv_run_dimension_suffix pay_balance_dimensions.database_item_suffix%TYPE;

Line 3637: ln_payroll_action_id pay_assignment_actions.payroll_action_id%TYPE;

3633:
3634: ln_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
3635: ln_assignment_id pay_assignment_actions.assignment_id%TYPE;
3636: ln_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
3637: ln_payroll_action_id pay_assignment_actions.payroll_action_id%TYPE;
3638:
3639: lv_gross_balance pay_balance_types.balance_name%TYPE;
3640: lv_run_dimension_suffix pay_balance_dimensions.database_item_suffix%TYPE;
3641:

Line 4606: pay_assignment_actions paa

4602: IS
4603: SELECT payslipv.effective_date,
4604: payslipv.action_context_id
4605: FROM pay_emp_payslip_action_info_v payslipv,
4606: pay_assignment_actions paa
4607: WHERE paa.assignment_id = cp_assignment_id
4608: AND payslipv.person_id = cp_person_id
4609: AND payslipv.action_context_id = paa.assignment_action_id
4610: AND payslipv.effective_date < cp_effective_date

Line 4627: ln_archive_action_id pay_assignment_actions.assignment_action_id%TYPE;

4623: lv_legislation_code VARCHAR2(2);
4624: ld_effective_date DATE;
4625:
4626: ld_last_payslip_date DATE;
4627: ln_archive_action_id pay_assignment_actions.assignment_action_id%TYPE;
4628:
4629: ln_person_id per_all_assignments_f.person_id%TYPE;
4630: ln_payroll_id per_all_assignments_f.payroll_id%TYPE;
4631: ln_pay_basis_id per_all_assignments_f.pay_basis_id%TYPE;