DBA Data[Home] [Help]

APPS.PY_ROLLBACK_PKG dependencies on PAY_BATCH_LINES

Line 2071: pay_batch_lines pbl

2067: or
2068: (p_info.action_type = 'BEE'
2069: and ASS.effective_start_date = (select max(ASS2.effective_start_date)
2070: from per_all_assignments_f ASS2,
2071: pay_batch_lines pbl
2072: where ASS2.assignment_id = ASS.assignment_id
2073: and pbl.batch_id (+) = p_info.batch_id
2074: and pbl.assignment_id (+) = ASS.assignment_id
2075: and pbl.effective_Date (+) between ASS2.effective_start_date

Line 2079: pay_batch_lines pbl

2075: and pbl.effective_Date (+) between ASS2.effective_start_date
2076: and ASS2.effective_end_date)
2077: and PEO.effective_start_date = (select max(PEO2.effective_start_date)
2078: from per_all_people_f PEO2,
2079: pay_batch_lines pbl
2080: where PEO2.person_id = PEO.person_id
2081: and PEO2.person_id = ASS.person_id
2082: and pbl.batch_id (+) = p_info.batch_id
2083: and pbl.assignment_id (+) = ASS.assignment_id

Line 2648: pay_batch_lines pbl

2644: or
2645: (p_info.action_type = 'BEE'
2646: and asg.effective_start_date = (select max(ASS2.effective_start_date)
2647: from per_all_assignments_f ASS2,
2648: pay_batch_lines pbl
2649: where ASS2.assignment_id = asg.assignment_id
2650: and pbl.batch_id (+) = p_info.batch_id
2651: and pbl.assignment_id (+) = asg.assignment_id
2652: and pbl.effective_Date (+) between ASS2.effective_start_date