DBA Data[Home] [Help]

APPS.HR_JPBAL dependencies on PER_TIME_PERIODS

Line 1060: per_time_periods ptp

1056: SELECT /*+ ORDERED */
1057: ptp.end_date
1058: FROM pay_assignment_actions paa,
1059: pay_payroll_actions ppa,
1060: per_time_periods ptp
1061: WHERE paa.assignment_action_id = c_assignment_action_id
1062: AND ppa.payroll_action_id = paa.payroll_action_id
1063: AND ptp.time_period_id = ppa.time_period_id;
1064: --

Line 1209: per_time_periods ptp

1205: SELECT /*+ ORDERED */
1206: ptp.end_date
1207: FROM pay_assignment_actions paa,
1208: pay_payroll_actions ppa,
1209: per_time_periods ptp
1210: WHERE paa.assignment_action_id = c_assignment_action_id
1211: AND ppa.payroll_action_id = paa.payroll_action_id
1212: AND ptp.time_period_id = ppa.time_period_id;
1213: --

Line 2529: per_time_periods ptp

2525: SELECT /*+ ORDERED */
2526: ptp.end_date
2527: FROM pay_assignment_actions paa,
2528: pay_payroll_actions ppa,
2529: per_time_periods ptp
2530: WHERE paa.assignment_action_id = c_assignment_action_id
2531: AND ppa.payroll_action_id = paa.payroll_action_id
2532: AND ptp.time_period_id = ppa.time_period_id;
2533: --

Line 2675: per_time_periods ptp

2671: SELECT /*+ ORDERED */
2672: ptp.end_date
2673: FROM pay_assignment_actions paa,
2674: pay_payroll_actions ppa,
2675: per_time_periods ptp
2676: WHERE paa.assignment_action_id = c_assignment_action_id
2677: AND ppa.payroll_action_id = paa.payroll_action_id
2678: AND ptp.time_period_id = ppa.time_period_id;
2679: --