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.PQP_NL_PGGM_FUNCTIONS dependencies on PAY_PAYROLL_ACTIONS

Line 18: FROM pay_payroll_actions PACTION

14:
15:
16: CURSOR c_get_num_periods_per_year(c_payroll_action_id IN NUMBER) IS
17: SELECT TPTYPE.number_per_fiscal_year
18: FROM pay_payroll_actions PACTION
19: ,per_time_periods TPERIOD
20: ,per_time_period_types TPTYPE
21: WHERE PACTION.payroll_action_id = c_payroll_action_id
22: AND TPERIOD.payroll_id = PACTION.payroll_id

Line 744: FROM pay_payroll_actions PACTION

740: --
741: CURSOR c_get_period_type(c_payroll_action_id IN NUMBER)
742: IS
743: SELECT TPERIOD.period_type
744: FROM pay_payroll_actions PACTION
745: ,per_time_periods TPERIOD
746: WHERE PACTION.payroll_action_id = c_payroll_action_id
747: AND TPERIOD.payroll_id = PACTION.payroll_id
748: AND (PACTION.date_earned between TPERIOD.start_date

Line 1763: FROM pay_payroll_actions PACTION

1759: --
1760: CURSOR c_get_period_type(c_payroll_action_id IN NUMBER)
1761: IS
1762: SELECT TPERIOD.period_type
1763: FROM pay_payroll_actions PACTION
1764: ,per_time_periods TPERIOD
1765: WHERE PACTION.payroll_action_id = c_payroll_action_id
1766: AND TPERIOD.payroll_id = PACTION.payroll_id
1767: AND (PACTION.date_earned between TPERIOD.start_date