DBA Data[Home] [Help]

APPS.PAY_CORE_UTILS dependencies on PAY_LEGISLATION_CONTEXTS

Line 36: g_leg_code pay_legislation_contexts.legislation_code%type := null;

32: g_message_stack message_stack_type;
33: g_message_tokens message_token;
34: --
35: g_legislation_code PER_BUSINESS_GROUPS.LEGISLATION_CODE%TYPE;
36: g_leg_code pay_legislation_contexts.legislation_code%type := null;
37: --
38: g_process_path varchar2(2000);
39: g_asg_action_id pay_assignment_actions.assignment_action_id%type;
40: --

Line 1313: from pay_legislation_contexts plc,

1309: ,'SOURCE_TEXT2' ,'SOURCE_TEXT2_IV'
1310: ,'SOURCE_NUMBER' ,'SOURCE_NUMBER_IV'
1311: ,null
1312: ) rule_type
1313: from pay_legislation_contexts plc,
1314: ff_contexts fc
1315: where plc.legislation_code(+) = p_legislation
1316: and plc.context_id (+) = fc.context_id
1317: and fc.context_name in

Line 1363: -- No row in pay_legislation_contexts

1359: --
1360: l_iv_name := l_rec.input_value_name;
1361: else
1362: --
1363: -- No row in pay_legislation_contexts
1364: -- Thus see if there is a leg rule
1365: -- Derive the name from legislation rule.
1366: --
1367: if (l_rec.rule_type is not null) then

Line 2159: l_context_iv_name pay_legislation_contexts.input_value_name%type;

2155: Function get_context_iv_name (p_asg_act_id in number,
2156: p_context in varchar2) return varchar2
2157: is
2158: --
2159: l_context_iv_name pay_legislation_contexts.input_value_name%type;
2160: l_found boolean;
2161: --
2162: begin
2163: --