eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQP_NL_ABP_FUNCTIONS dependencies on PER_TIME_PERIODS

Line 3849: ,per_time_periods ptp

3845: --for the particular assignment
3846: CURSOR c_get_period_dates IS
3847: SELECT ptp.start_date,ptp.end_date
3848: FROM per_all_assignments_f asg
3849: ,per_time_periods ptp
3850: WHERE asg.assignment_id = p_assignment_id
3851: AND asg.payroll_id = ptp.payroll_id
3852: AND p_date_earned BETWEEN ptp.start_date
3853: AND ptp.end_date;

Line 6023: ,per_time_periods ptp

6019: --for the particular assignment
6020: CURSOR c_get_period_dates IS
6021: SELECT ptp.start_date,ptp.end_date
6022: FROM per_all_assignments_f asg
6023: ,per_time_periods ptp
6024: WHERE asg.assignment_id = p_assignment_id
6025: AND asg.payroll_id = ptp.payroll_id
6026: AND p_date_earned BETWEEN ptp.start_date
6027: AND ptp.end_date;

Line 6224: ,per_time_periods ptp

6220: --for the particular assignment
6221: CURSOR c_get_period_dates IS
6222: SELECT ptp.start_date,ptp.end_date
6223: FROM per_all_assignments_f asg
6224: ,per_time_periods ptp
6225: WHERE asg.assignment_id = p_assignment_id
6226: AND asg.payroll_id = ptp.payroll_id
6227: AND p_date_earned BETWEEN ptp.start_date
6228: AND ptp.end_date;