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