DBA Data[Home] [Help]

APPS.PAY_BEE_UPGRADE_PKG dependencies on PAY_BATCH_HEADERS

Line 34: pay_batch_headers pbh

30: pbl.assignment_id,
31: pbl.assignment_number,
32: pbl.batch_line_status
33: FROM pay_batch_lines pbl,
34: pay_batch_headers pbh
35: WHERE pbl.assignment_id is not null
36: AND pbl.assignment_id = p_assignment_id
37: AND pbh.business_group_id = p_bg_id
38: AND pbh.batch_id = pbl.batch_id

Line 66: pay_batch_headers pbh,

62: asg.assignment_id,
63: pbl.assignment_number,
64: pbl.batch_line_status
65: FROM pay_batch_lines pbl,
66: pay_batch_headers pbh,
67: per_all_assignments_f asg
68: WHERE pbh.business_group_id = p_bg_id
69: AND pbl.assignment_id is null
70: AND asg.assignment_id = p_assignment_id

Line 102: pay_batch_headers pbh

98: pbl.assignment_id,
99: pbl.assignment_number,
100: pbl.batch_line_status
101: FROM pay_batch_lines pbl,
102: pay_batch_headers pbh
103: WHERE pbh.business_group_id = p_bg_id
104: AND pbl.assignment_id is null
105: AND (pbl.assignment_number is null or
106: not exists