DBA Data[Home] [Help]

APPS.PAY_SLA_UPDATE_PKG dependencies on GL_JE_LINES

Line 727: update gl_je_lines

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

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

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

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

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

Line 1032: gl_je_lines gjl

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

Line 1093: gl_je_lines gjl

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