APPS.PAY_CORE_UTILS dependencies on PAY_INPUT_VALUES_F

Line 46: ,jurisdiction_iv pay_input_values_f.name%type

42: --
43: type t_leg_context_iv_rec is record
44: (legislation_code per_business_groups.legislation_code%type
45: ,non_oracle_local varchar2(30)
46: ,jurisdiction_iv pay_input_values_f.name%type
47: ,source_id_iv pay_input_values_f.name%type
48: ,source_text_iv pay_input_values_f.name%type
49: ,source_number_iv pay_input_values_f.name%type
50: ,source_number2_iv pay_input_values_f.name%type

Line 47: ,source_id_iv pay_input_values_f.name%type

43: type t_leg_context_iv_rec is record
44: (legislation_code per_business_groups.legislation_code%type
45: ,non_oracle_local varchar2(30)
46: ,jurisdiction_iv pay_input_values_f.name%type
47: ,source_id_iv pay_input_values_f.name%type
48: ,source_text_iv pay_input_values_f.name%type
49: ,source_number_iv pay_input_values_f.name%type
50: ,source_number2_iv pay_input_values_f.name%type
51: ,source_text2_iv pay_input_values_f.name%type

Line 48: ,source_text_iv pay_input_values_f.name%type

44: (legislation_code per_business_groups.legislation_code%type
45: ,non_oracle_local varchar2(30)
46: ,jurisdiction_iv pay_input_values_f.name%type
47: ,source_id_iv pay_input_values_f.name%type
48: ,source_text_iv pay_input_values_f.name%type
49: ,source_number_iv pay_input_values_f.name%type
50: ,source_number2_iv pay_input_values_f.name%type
51: ,source_text2_iv pay_input_values_f.name%type
52: ,organization_id_iv pay_input_values_f.name%type

Line 49: ,source_number_iv pay_input_values_f.name%type

45: ,non_oracle_local varchar2(30)
46: ,jurisdiction_iv pay_input_values_f.name%type
47: ,source_id_iv pay_input_values_f.name%type
48: ,source_text_iv pay_input_values_f.name%type
49: ,source_number_iv pay_input_values_f.name%type
50: ,source_number2_iv pay_input_values_f.name%type
51: ,source_text2_iv pay_input_values_f.name%type
52: ,organization_id_iv pay_input_values_f.name%type
53: );

Line 50: ,source_number2_iv pay_input_values_f.name%type

46: ,jurisdiction_iv pay_input_values_f.name%type
47: ,source_id_iv pay_input_values_f.name%type
48: ,source_text_iv pay_input_values_f.name%type
49: ,source_number_iv pay_input_values_f.name%type
50: ,source_number2_iv pay_input_values_f.name%type
51: ,source_text2_iv pay_input_values_f.name%type
52: ,organization_id_iv pay_input_values_f.name%type
53: );
54: --

Line 51: ,source_text2_iv pay_input_values_f.name%type

47: ,source_id_iv pay_input_values_f.name%type
48: ,source_text_iv pay_input_values_f.name%type
49: ,source_number_iv pay_input_values_f.name%type
50: ,source_number2_iv pay_input_values_f.name%type
51: ,source_text2_iv pay_input_values_f.name%type
52: ,organization_id_iv pay_input_values_f.name%type
53: );
54: --
55: g_leg_context_iv_rec t_leg_context_iv_rec;

Line 52: ,organization_id_iv pay_input_values_f.name%type

48: ,source_text_iv pay_input_values_f.name%type
49: ,source_number_iv pay_input_values_f.name%type
50: ,source_number2_iv pay_input_values_f.name%type
51: ,source_text2_iv pay_input_values_f.name%type
52: ,organization_id_iv pay_input_values_f.name%type
53: );
54: --
55: g_leg_context_iv_rec t_leg_context_iv_rec;
56: --

Line 1297: l_iv_name pay_input_values_f.name%type;

1293: p_inp_val_name out nocopy varchar2,
1294: p_found out nocopy boolean
1295: )
1296: is
1297: l_iv_name pay_input_values_f.name%type;
1298: l_inp_val_name pay_input_values_f.name%type;
1299: l_found boolean;
1300: l_approved boolean;
1301: --

Line 1298: l_inp_val_name pay_input_values_f.name%type;

1294: p_found out nocopy boolean
1295: )
1296: is
1297: l_iv_name pay_input_values_f.name%type;
1298: l_inp_val_name pay_input_values_f.name%type;
1299: l_found boolean;
1300: l_approved boolean;
1301: --
1302: cursor csr_leg_contexts is

Line 1498: l_inp_val_name pay_input_values_f.name%type;

1494: 'SOURCE_TEXT2',
1495: 'SOURCE_NUMBER2',
1496: 'ORGANIZATION_ID');
1497: --
1498: l_inp_val_name pay_input_values_f.name%type;
1499: l_default boolean;
1500: l_plsql varchar2(60);
1501: --
1502: l_legrul_value pay_legislation_rules.rule_mode%type;

Line 1618: from pay_input_values_f piv,

1614: begin
1615: --
1616: select distinct piv.input_value_id
1617: into l_ivid
1618: from pay_input_values_f piv,
1619: pay_element_entry_values_f peev
1620: where peev.element_entry_id = p_ee_id
1621: and peev.input_value_id = piv.input_value_id
1622: and piv.name = p_context_name;