DBA Data[Home] [Help]

APPS.HR_US_FF_UDF1 dependencies on PER_TIME_PERIOD_TYPES

Line 6005: FROM per_time_period_types pttt,

6001: IS
6002:
6003: CURSOR get_number_periods_per_year IS
6004: SELECT number_per_fiscal_year
6005: FROM per_time_period_types pttt,
6006: pay_all_payrolls_f papf
6007: WHERE pttt.period_type=papf.period_type
6008: AND papf.payroll_id=p_payroll_id;
6009:

Line 6015: l_num_periods_per_year per_time_period_types.number_per_fiscal_year%TYPE;

6011: SELECT assignment_number
6012: FROM per_all_assignments_f
6013: WHERE assignment_id=p_assignment_id;
6014:
6015: l_num_periods_per_year per_time_period_types.number_per_fiscal_year%TYPE;
6016: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
6017: l_ht_deducted NUMBER;
6018:
6019: BEGIN