APPS.PAY_SLA_UPDATE_PKG dependencies on GL_JE_LINES

Line 730: update gl_je_lines

726: update gl_je_headers
727: set je_from_sla_flag='Y'
728: where je_header_id=l.je_header_id;
729:
730: update gl_je_lines
731: set gl_sl_link_id=XLA_GL_SL_LINK_ID_S.nextval ,
732: gl_sl_link_table='XLAJEL'
733: where je_header_id =l.je_header_id;
734:

Line 736: set gir.gl_sl_link_id = (select gl_sl_link_id from gl_je_lines gjl1

732: gl_sl_link_table='XLAJEL'
733: where je_header_id =l.je_header_id;
734:
735: update gl_import_references gir
736: set gir.gl_sl_link_id = (select gl_sl_link_id from gl_je_lines gjl1
737: where gir.je_header_id = gjl1.je_header_id
738: and gir.je_line_num=gjl1.je_line_num),
739: gir.gl_sl_link_table ='XLAJEL'
740: where gir.je_header_id = l.je_header_id

Line 741: and gir.je_line_num = (select je_line_num from gl_je_lines gjl

737: where gir.je_header_id = gjl1.je_header_id
738: and gir.je_line_num=gjl1.je_line_num),
739: gir.gl_sl_link_table ='XLAJEL'
740: where gir.je_header_id = l.je_header_id
741: and gir.je_line_num = (select je_line_num from gl_je_lines gjl
742: where gir.je_header_id = gjl.je_header_id
743: and gir.je_line_num=gjl.je_line_num);
744:
745: End loop;

Line 1035: gl_je_lines gjl

1031: pay_assignment_actions pa, -- Trans GL asg actions
1032: pay_payroll_actions ppa, -- Trans GL pay actions
1033: pay_costs_v pcv,
1034: gl_je_headers gjh,
1035: gl_je_lines gjl
1036: WHERE ppa.payroll_action_id = to_number(gjl.reference_1)
1037: AND pa.payroll_action_id = ppa.payroll_action_id
1038: AND pa.action_status = 'C'
1039: AND ppa2.payroll_action_id = to_number(gjl.reference_5)

Line 1096: gl_je_lines gjl

1092: per_all_assignments_f pera,
1093: pay_all_payrolls_f pp,
1094: pay_payment_costs_v ppc,
1095: gl_je_headers gjh,
1096: gl_je_lines gjl
1097: WHERE ppa.payroll_action_id = to_number(gjl.reference_1)
1098: AND pa.payroll_action_id = ppa.payroll_action_id
1099: AND pi1.locking_action_id = pa.assignment_action_id
1100: AND pa1.assignment_action_id = pi1.locked_action_id