APPS.PY_ROLLBACK_PKG dependencies on PAY_BATCH_LINES

Line 2150: pay_batch_lines pbl

2146: or
2147: (p_info.action_type = 'BEE'
2148: and ASS.effective_start_date = (select max(ASS2.effective_start_date)
2149: from per_all_assignments_f ASS2,
2150: pay_batch_lines pbl
2151: where ASS2.assignment_id = ASS.assignment_id
2152: and pbl.batch_id (+) = p_info.batch_id
2153: and pbl.assignment_id (+) = ASS.assignment_id
2154: and pbl.effective_Date (+) between ASS2.effective_start_date

Line 2158: pay_batch_lines pbl

2154: and pbl.effective_Date (+) between ASS2.effective_start_date
2155: and ASS2.effective_end_date)
2156: and PEO.effective_start_date = (select max(PEO2.effective_start_date)
2157: from per_all_people_f PEO2,
2158: pay_batch_lines pbl
2159: where PEO2.person_id = PEO.person_id
2160: and PEO2.person_id = ASS.person_id
2161: and pbl.batch_id (+) = p_info.batch_id
2162: and pbl.assignment_id (+) = ASS.assignment_id

Line 2736: pay_batch_lines pbl

2732: /* or
2733: (p_info.action_type = 'BEE'
2734: and asg.effective_start_date = (select max(ASS2.effective_start_date)
2735: from per_all_assignments_f ASS2,
2736: pay_batch_lines pbl
2737: where ASS2.assignment_id = asg.assignment_id
2738: and pbl.batch_id (+) = p_info.batch_id
2739: and pbl.assignment_id (+) = asg.assignment_id
2740: and pbl.effective_Date (+) between ASS2.effective_start_date

Line 2763: pay_batch_lines pbl

2759: and act.source_action_id is null
2760: and p_info.action_type = 'BEE'
2761: and asg.effective_start_date = (select max(ASS2.effective_start_date)
2762: from per_all_assignments_f ASS2,
2763: pay_batch_lines pbl
2764: where ASS2.assignment_id = asg.assignment_id
2765: and pbl.batch_id (+) = p_info.batch_id
2766: and pbl.assignment_id (+) = asg.assignment_id
2767: and pbl.effective_Date (+) between ASS2.effective_start_date