[Home] [Help]
1473: CURSOR csr_prepay_found (p_locked_action NUMBER,
1474: p_rr_action NUMBER,
1475: p_dimension_name VARCHAR2, --6633719 3new pmtr added
1476: p_context_id number,
1477: p_context_value pay_action_contexts.CONTEXT_VALUE%type ) IS
1478: SELECT NVL (SUBSTR (ppf.national_identifier, 1, 9), ' '), -- PPSN
1479: -- for bug 5301598, increased the size to 12
1480: NVL (SUBSTR (paf.assignment_number, 1, 12), ' '), --WORKS NUMBER
1481: paf.person_id, -- FOR CALCULATION
1675: /* cursor for payroll run results data */
1676: CURSOR csr_run_results_found (p_locked_action NUMBER,
1677: p_dimension_name VARCHAR2, --6633719 3new pmtr added
1678: p_context_id number,
1679: p_context_value pay_action_contexts.CONTEXT_VALUE%type )
1680: IS
1681: SELECT NVL (SUBSTR (ppf.national_identifier, 1, 9), ' '), --PPSN
1682: -- for bug 5301598, increased the size to 12
1683: NVL (SUBSTR (paf.assignment_number, 1, 12), ' '), -- WORKS NUMBER
2147:
2148:
2149: CURSOR Cur_Act_Contexts(p_source_id number) IS
2150: SELECT pac.context_id, pac.context_value
2151: FROM pay_action_contexts pac, ff_contexts ffc
2152: WHERE pac.assignment_action_id = p_source_id
2153: AND ffc.context_name = 'SOURCE_TEXT'
2154: AND ffc.context_id = pac.context_id;
2155:
2152: WHERE pac.assignment_action_id = p_source_id
2153: AND ffc.context_name = 'SOURCE_TEXT'
2154: AND ffc.context_id = pac.context_id;
2155:
2156: l_Act_Context_id pay_action_contexts.context_id%type;
2157: l_Act_Context_value pay_action_contexts.context_value%type;
2158:
2159: --6633719
2160:
2153: AND ffc.context_name = 'SOURCE_TEXT'
2154: AND ffc.context_id = pac.context_id;
2155:
2156: l_Act_Context_id pay_action_contexts.context_id%type;
2157: l_Act_Context_value pay_action_contexts.context_value%type;
2158:
2159: --6633719
2160:
2161: BEGIN