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 898: FROM pay_payroll_actions PACTION

894: --
895: CURSOR c_get_period_type(c_payroll_action_id IN NUMBER)
896: IS
897: SELECT TPERIOD.period_type
898: FROM pay_payroll_actions PACTION
899: ,per_time_periods TPERIOD
900: WHERE PACTION.payroll_action_id = c_payroll_action_id
901: AND TPERIOD.payroll_id = PACTION.payroll_id
902: AND (PACTION.date_earned between TPERIOD.start_date

Line 1917: FROM pay_payroll_actions PACTION

1913: --
1914: CURSOR c_get_period_type(c_payroll_action_id IN NUMBER)
1915: IS
1916: SELECT TPERIOD.period_type
1917: FROM pay_payroll_actions PACTION
1918: ,per_time_periods TPERIOD
1919: WHERE PACTION.payroll_action_id = c_payroll_action_id
1920: AND TPERIOD.payroll_id = PACTION.payroll_id
1921: AND (PACTION.date_earned between TPERIOD.start_date