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 899: ,per_time_periods TPERIOD

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

Line 1371: FROM per_time_periods PTP

1367: CURSOR c_get_period_start_date ( c_year IN VARCHAR2
1368: )
1369: IS
1370: SELECT NVL(min(PTP.start_date),to_date('0101'||c_year,'DDMMYYYY'))
1371: FROM per_time_periods PTP
1372: WHERE
1373: PTP.payroll_id = p_payroll_id
1374: AND (substr(PTP.period_name,4,4)=c_year
1375: OR substr(PTP.period_name,3,4)=c_year);

Line 1918: ,per_time_periods TPERIOD

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