APPS.PQP_PENSION_FUNCTIONS dependencies on PER_TIME_PERIOD_TYPES

Line 42: FROM per_time_period_types_tl

38: ,p_payroll_period_fetch varchar2) RETURN BOOLEAN IS
39:
40: CURSOR c_get_payroll_period IS
41: SELECT display_period_type
42: FROM per_time_period_types_tl
43: WHERE period_type = p_payroll_period_fetch;
44:
45: flag BOOLEAN := FALSE;
46:

Line 586: from per_time_period_types

582: AND assignment_id = c_assignment_id;
583:
584: Cursor c_get_periods_per_yr(c_period_type in VARCHAR2) IS
585: Select number_per_fiscal_year
586: from per_time_period_types
587: where period_type = c_period_type;
588:
589:
590: l_average_days_divisor NUMBER;

Line 2164: ,per_time_period_types pety

2160: -- =======================================================================
2161: CURSOR c_pp_cur IS
2162: SELECT pety.number_per_fiscal_year
2163: FROM pay_payrolls_f ppaf
2164: ,per_time_period_types pety
2165: WHERE ppaf.payroll_id = p_payroll_id
2166: AND ppaf.period_type = pety.period_type;
2167:
2168: -- =======================================================================

Line 4615: from per_time_period_types

4611: AND rownum = 1;
4612:
4613: Cursor c_get_periods_per_yr(c_period_type in VARCHAR2) IS
4614: Select number_per_fiscal_year
4615: from per_time_period_types
4616: where period_type = c_period_type;
4617:
4618: BEGIN
4619: