DBA Data[Home] [Help]

APPS.HR_JPBAL dependencies on PER_TIME_PERIODS

Line 1080: per_time_periods ptp

1076: SELECT /*+ ORDERED */
1077: ptp.end_date
1078: FROM pay_assignment_actions paa,
1079: pay_payroll_actions ppa,
1080: per_time_periods ptp
1081: WHERE paa.assignment_action_id = c_assignment_action_id
1082: AND ppa.payroll_action_id = paa.payroll_action_id
1083: AND ptp.time_period_id = ppa.time_period_id;
1084: --

Line 1229: per_time_periods ptp

1225: SELECT /*+ ORDERED */
1226: ptp.end_date
1227: FROM pay_assignment_actions paa,
1228: pay_payroll_actions ppa,
1229: per_time_periods ptp
1230: WHERE paa.assignment_action_id = c_assignment_action_id
1231: AND ppa.payroll_action_id = paa.payroll_action_id
1232: AND ptp.time_period_id = ppa.time_period_id;
1233: --

Line 2549: per_time_periods ptp

2545: SELECT /*+ ORDERED */
2546: ptp.end_date
2547: FROM pay_assignment_actions paa,
2548: pay_payroll_actions ppa,
2549: per_time_periods ptp
2550: WHERE paa.assignment_action_id = c_assignment_action_id
2551: AND ppa.payroll_action_id = paa.payroll_action_id
2552: AND ptp.time_period_id = ppa.time_period_id;
2553: --

Line 2695: per_time_periods ptp

2691: SELECT /*+ ORDERED */
2692: ptp.end_date
2693: FROM pay_assignment_actions paa,
2694: pay_payroll_actions ppa,
2695: per_time_periods ptp
2696: WHERE paa.assignment_action_id = c_assignment_action_id
2697: AND ppa.payroll_action_id = paa.payroll_action_id
2698: AND ptp.time_period_id = ppa.time_period_id;
2699: --