[Home] [Help]
1812: CURSOR csr_prepay_found (p_locked_action NUMBER,
1813: p_rr_action NUMBER,
1814: p_dimension_name VARCHAR2, --6633719 3new pmtr added
1815: p_context_id number,
1816: p_context_value pay_action_contexts.CONTEXT_VALUE%type ) IS
1817: SELECT NVL (SUBSTR (ppf.national_identifier, 1, 9), ' '), -- PPSN
1818: -- for bug 5301598, increased the size to 12
1819: NVL (SUBSTR (paf.assignment_number, 1, 12), ' '), --WORKS NUMBER
1820: paf.person_id, -- FOR CALCULATION
2048: /* cursor for payroll run results data */
2049: CURSOR csr_run_results_found (p_locked_action NUMBER,
2050: p_dimension_name VARCHAR2, --6633719 3new pmtr added
2051: p_context_id number,
2052: p_context_value pay_action_contexts.CONTEXT_VALUE%type )
2053: IS
2054: SELECT NVL (SUBSTR (ppf.national_identifier, 1, 9), ' '), --PPSN
2055: -- for bug 5301598, increased the size to 12
2056: NVL (SUBSTR (paf.assignment_number, 1, 12), ' '), -- WORKS NUMBER
2596:
2597:
2598: CURSOR Cur_Act_Contexts(p_source_id number) IS
2599: SELECT pac.context_id, pac.context_value
2600: FROM pay_action_contexts pac, ff_contexts ffc
2601: WHERE pac.assignment_action_id = p_source_id
2602: AND ffc.context_name = 'SOURCE_TEXT'
2603: AND ffc.context_id = pac.context_id;
2604:
2601: WHERE pac.assignment_action_id = p_source_id
2602: AND ffc.context_name = 'SOURCE_TEXT'
2603: AND ffc.context_id = pac.context_id;
2604:
2605: l_Act_Context_id pay_action_contexts.context_id%type;
2606: l_Act_Context_value pay_action_contexts.context_value%type;
2607:
2608: --6633719
2609:
2602: AND ffc.context_name = 'SOURCE_TEXT'
2603: AND ffc.context_id = pac.context_id;
2604:
2605: l_Act_Context_id pay_action_contexts.context_id%type;
2606: l_Act_Context_value pay_action_contexts.context_value%type;
2607:
2608: --6633719
2609:
2610: --12382953