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 1426: from pay_legislation_contexts plc,

1422: ,'SOURCE_TEXT2' ,'SOURCE_TEXT2_IV'
1423: ,'SOURCE_NUMBER' ,'SOURCE_NUMBER_IV'
1424: ,null
1425: ) rule_type
1426: from pay_legislation_contexts plc,
1427: ff_contexts fc
1428: where plc.legislation_code(+) = p_legislation
1429: and plc.context_id (+) = fc.context_id
1430: and fc.context_name in

Line 1476: -- No row in pay_legislation_contexts

1472: --
1473: l_iv_name := l_rec.input_value_name;
1474: else
1475: --
1476: -- No row in pay_legislation_contexts
1477: -- Thus see if there is a leg rule
1478: -- Derive the name from legislation rule.
1479: --
1480: if (l_rec.rule_type is not null) then

Line 2280: l_context_iv_name pay_legislation_contexts.input_value_name%type;

2276: Function get_context_iv_name (p_asg_act_id in number,
2277: p_context in varchar2) return varchar2
2278: is
2279: --
2280: l_context_iv_name pay_legislation_contexts.input_value_name%type;
2281: l_found boolean;
2282: --
2283: begin
2284: --