APPS.PAY_PAYWSQEE_PKG dependencies on PAY_BATCH_LINES

Line 805: from pay_batch_lines

801: v_batch_sequence number := null;
802: --
803: cursor csr_next_batch_sequence is
804: select nvl (max (batch_sequence), 0) +1
805: from pay_batch_lines
806: where batch_id = p_batch_id;
807: --
808: begin
809: --

Line 835: from pay_batch_lines

831: from pay_batch_control_totals
832: where batch_id = p_batch_id
833: union
834: select batch_line_status
835: from pay_batch_lines
836: where batch_id = p_batch_id
837: union
838: select batch_status
839: from pay_batch_headers

Line 925: pay_batch_lines LINE

921: --
922: cursor csr_element is
923: select distinct elt.element_type_id, elt.element_name
924: from pay_element_types_f ELT,
925: pay_batch_lines LINE
926: where line.batch_id = p_batch_id and
927: line.element_type_id is not null and
928: line.element_type_id = elt.element_type_id
929: union

Line 932: pay_batch_lines LINE

928: line.element_type_id = elt.element_type_id
929: union
930: select distinct elt.element_type_id, elt.element_name
931: from pay_element_types_f ELT,
932: pay_batch_lines LINE
933: where line.batch_id = p_batch_id and
934: line.element_type_id is null and
935: upper (line.element_name) = upper(elt.element_name);
936: --