[Home] [Help]
669: and phase = p_process_name||p_mgr_req_id
670: and patch_number=p_ledger_id
671: and status is null;
672:
673: Cursor csr_get_headers(p_ledger_id in gl_je_headers.ledger_id%type,
674: p_period_name in gl_je_headers.period_name%type,
675: p_app_name in varchar2)
676: is
677: select je_header_id
670: and patch_number=p_ledger_id
671: and status is null;
672:
673: Cursor csr_get_headers(p_ledger_id in gl_je_headers.ledger_id%type,
674: p_period_name in gl_je_headers.period_name%type,
675: p_app_name in varchar2)
676: is
677: select je_header_id
678: from gl_je_headers gjh
674: p_period_name in gl_je_headers.period_name%type,
675: p_app_name in varchar2)
676: is
677: select je_header_id
678: from gl_je_headers gjh
679: where gjh.period_name=p_period_name
680: and gjh.je_category=p_app_name
681: and gjh.ledger_id=p_ledger_id
682: and gjh.je_source=p_app_name
719:
720: For l in csr_get_headers(j.ledger_id,j.period_name,lv_application_name)
721: Loop
722:
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
1027: pay_action_interlocks pi2, -- Run - Trans GL
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'
1088: pay_payroll_actions ppa1, -- Cost pay actions
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