APPS.PAY_BEE_UPGRADE_PKG dependencies on PAY_BATCH_LINES

Line 33: FROM pay_batch_lines pbl,

29: pbl.element_name,
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

Line 65: FROM pay_batch_lines pbl,

61: pbl.element_name,
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

Line 101: FROM pay_batch_lines pbl,

97: pbl.element_name,
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

Line 138: g_effective_date pay_batch_lines.effective_date%TYPE := NULL;

134: --
135: g_input_values input_value_tbl_rec;
136: g_element_type_id pay_element_types_f.element_type_id%TYPE := NULL;
137: g_element_name pay_element_types_f.element_name%TYPE := NULL;
138: g_effective_date pay_batch_lines.effective_date%TYPE := NULL;
139: g_business_group_id per_business_groups.business_group_id%TYPE := NULL;
140: g_legislation_code per_business_groups.legislation_code%TYPE := NULL;
141: --
142: type input_value_rec is record(

Line 656: update pay_batch_lines

652: begin
653: --
654: payplnk.g_payplnk_call := true;
655: --
656: update pay_batch_lines
657: set value_1 = l_temp.value_1,
658: value_2 = l_temp.value_2,
659: value_3 = l_temp.value_3,
660: value_4 = l_temp.value_4,