DBA Data[Home] [Help]

APPS.PAY_GB_RTI_FPS dependencies on PER_TIME_PERIOD_TYPES

Line 1445: FROM per_time_period_types ptpt

1441: --Below cursor fetches further period type details of the current assignment
1442: CURSOR csr_period_type_info(p_period_type VARCHAR2)
1443: IS
1444: SELECT ptpt.number_per_fiscal_year
1445: FROM per_time_period_types ptpt
1446: WHERE p_period_type = ptpt.period_type;
1447:
1448: --Below cursor fetches basic ni details of the current assignment
1449: CURSOR csr_ni_info(c_asg_id NUMBER, c_asg_eff_start_date DATE)

Line 2263: FROM per_time_period_types ptpt

2259: --Below cursor fetches further period type details of the current assignment
2260: CURSOR csr_period_type_info(p_period_type VARCHAR2)
2261: IS
2262: SELECT ptpt.number_per_fiscal_year
2263: FROM per_time_period_types ptpt
2264: WHERE p_period_type = ptpt.period_type;
2265:
2266: --Below cursor fetches basic ni details of the current assignment
2267: CURSOR csr_ni_info(c_asg_id NUMBER, c_asg_eff_start_date DATE)

Line 3076: FROM per_time_period_types ptpt

3072: --Below cursor fetches further period type details of the current assignment
3073: CURSOR csr_period_type_info(p_period_type VARCHAR2)
3074: IS
3075: SELECT ptpt.number_per_fiscal_year
3076: FROM per_time_period_types ptpt
3077: WHERE p_period_type = ptpt.period_type;
3078:
3079: --Below cursor fetches basic ni details of the current assignment
3080: CURSOR csr_ni_info(c_asg_id NUMBER, c_asg_eff_start_date DATE)