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 PER_TIME_PERIODS

Line 19: ,per_time_periods TPERIOD

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
23: AND (PACTION.date_earned between TPERIOD.start_date

Line 745: ,per_time_periods TPERIOD

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
749: and TPERIOD.end_date);

Line 1217: FROM per_time_periods PTP

1213: CURSOR c_get_period_start_date ( c_year IN VARCHAR2
1214: )
1215: IS
1216: SELECT NVL(min(PTP.start_date),to_date('0101'||c_year,'DDMMYYYY'))
1217: FROM per_time_periods PTP
1218: WHERE
1219: PTP.payroll_id = p_payroll_id
1220: AND (substr(PTP.period_name,4,4)=c_year
1221: OR substr(PTP.period_name,3,4)=c_year);

Line 1764: ,per_time_periods TPERIOD

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
1768: and TPERIOD.end_date);