DBA Data[Home] [Help]

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 1410: l_iv_name pay_input_values_f.name%type;

1406: p_inp_val_name out nocopy varchar2,
1407: p_found out nocopy boolean
1408: )
1409: is
1410: l_iv_name pay_input_values_f.name%type;
1411: l_inp_val_name pay_input_values_f.name%type;
1412: l_found boolean;
1413: l_approved boolean;
1414: --

Line 1411: l_inp_val_name pay_input_values_f.name%type;

1407: p_found out nocopy boolean
1408: )
1409: is
1410: l_iv_name pay_input_values_f.name%type;
1411: l_inp_val_name pay_input_values_f.name%type;
1412: l_found boolean;
1413: l_approved boolean;
1414: --
1415: cursor csr_leg_contexts is

Line 1611: l_inp_val_name pay_input_values_f.name%type;

1607: 'SOURCE_TEXT2',
1608: 'SOURCE_NUMBER2',
1609: 'ORGANIZATION_ID');
1610: --
1611: l_inp_val_name pay_input_values_f.name%type;
1612: l_default boolean;
1613: l_plsql varchar2(60);
1614: --
1615: l_legrul_value pay_legislation_rules.rule_mode%type;

Line 1731: from pay_input_values_f piv,

1727: begin
1728: --
1729: select distinct piv.input_value_id
1730: into l_ivid
1731: from pay_input_values_f piv,
1732: pay_element_entry_values_f peev
1733: where peev.element_entry_id = p_ee_id
1734: and peev.input_value_id = piv.input_value_id
1735: and piv.name = p_context_name;

Line 2464: v_input_value_id pay_input_values_f.input_value_id%TYPE := null;

2460: p_flag IN VARCHAR2,
2461: p_status OUT NOCOPY varchar2
2462: ) IS
2463: lv_proc VARCHAR2(30) := 'update_prj_flag';
2464: v_input_value_id pay_input_values_f.input_value_id%TYPE := null;
2465: --
2466: CURSOR search_input_value_id (
2467: v_element_type_id pay_element_types_f.element_type_id%TYPE
2468: ) is

Line 2470: FROM pay_input_values_f

2466: CURSOR search_input_value_id (
2467: v_element_type_id pay_element_types_f.element_type_id%TYPE
2468: ) is
2469: SELECT DISTINCT input_value_id
2470: FROM pay_input_values_f
2471: WHERE element_type_id=v_element_type_id
2472: AND NAME = 'Pay Value';
2473: --
2474: BEGIN