DBA Data[Home] [Help]

APPS.PQP_PENSION_FUNCTIONS dependencies on PER_TIME_PERIOD_TYPES

Line 544: from per_time_period_types

540: AND assignment_id = c_assignment_id;
541:
542: Cursor c_get_periods_per_yr(c_period_type in VARCHAR2) IS
543: Select number_per_fiscal_year
544: from per_time_period_types
545: where period_type = c_period_type;
546:
547:
548: l_average_days_divisor NUMBER;

Line 2099: ,per_time_period_types pety

2095: -- =======================================================================
2096: CURSOR c_pp_cur IS
2097: SELECT pety.number_per_fiscal_year
2098: FROM pay_payrolls_f ppaf
2099: ,per_time_period_types pety
2100: WHERE ppaf.payroll_id = p_payroll_id
2101: AND ppaf.period_type = pety.period_type;
2102:
2103: -- =======================================================================

Line 4518: from per_time_period_types

4514: AND rownum = 1;
4515:
4516: Cursor c_get_periods_per_yr(c_period_type in VARCHAR2) IS
4517: Select number_per_fiscal_year
4518: from per_time_period_types
4519: where period_type = c_period_type;
4520:
4521: BEGIN
4522: