APPS.HR_GB_PROCESS_P11D_ENTRIES_PKG dependencies on PAY_INPUT_VALUES_F

Line 41: l_ben_start_date_id pay_input_values_f.input_value_id%type;

37: p_end_date in VARCHAR2,
38: p_bus_grp_id in pay_element_types_f.business_group_id%type,
39: p_assignment_set_id in Number )
40: is
41: l_ben_start_date_id pay_input_values_f.input_value_id%type;
42: l_ben_end_date_id pay_input_values_f.input_value_id%type;
43: l_element_name pay_element_types_f.element_name%type;
44: l_count NUMBER default 0;
45: l_effective_start_date_dummy DATE;

Line 42: l_ben_end_date_id pay_input_values_f.input_value_id%type;

38: p_bus_grp_id in pay_element_types_f.business_group_id%type,
39: p_assignment_set_id in Number )
40: is
41: l_ben_start_date_id pay_input_values_f.input_value_id%type;
42: l_ben_end_date_id pay_input_values_f.input_value_id%type;
43: l_element_name pay_element_types_f.element_name%type;
44: l_count NUMBER default 0;
45: l_effective_start_date_dummy DATE;
46: l_effective_end_date_dummy DATE;

Line 61: from pay_input_values_f piv

57: cursor csr_get_benefit_date_id(v_ben_date_type VARCHAR2,
58: v_element_type_id pay_element_types_f.element_type_id%type)
59: is
60: select input_value_id
61: from pay_input_values_f piv
62: where piv.element_type_id = v_element_type_id
63: and piv.NAME = v_ben_date_type;
64:
65: cursor csr_get_del_element_entry_id(v_ben_start_date_id pay_input_values_f.input_value_id%type,

Line 65: cursor csr_get_del_element_entry_id(v_ben_start_date_id pay_input_values_f.input_value_id%type,

61: from pay_input_values_f piv
62: where piv.element_type_id = v_element_type_id
63: and piv.NAME = v_ben_date_type;
64:
65: cursor csr_get_del_element_entry_id(v_ben_start_date_id pay_input_values_f.input_value_id%type,
66: v_start_date VARCHAR2,
67: v_ben_end_date_id pay_input_values_f.input_value_id%type,
68: v_end_date VARCHAR2,
69: v_bus_grp_id pay_element_types_f.business_group_id%type,

Line 67: v_ben_end_date_id pay_input_values_f.input_value_id%type,

63: and piv.NAME = v_ben_date_type;
64:
65: cursor csr_get_del_element_entry_id(v_ben_start_date_id pay_input_values_f.input_value_id%type,
66: v_start_date VARCHAR2,
67: v_ben_end_date_id pay_input_values_f.input_value_id%type,
68: v_end_date VARCHAR2,
69: v_bus_grp_id pay_element_types_f.business_group_id%type,
70: v_element_type_id pay_element_types_f.element_type_id%type)
71: is

Line 95: cursor csr_del_entries_assignset(v_ben_start_date_id pay_input_values_f.input_value_id%type,

91: from per_all_assignments_f paa
92: where paa.assignment_id = pee.assignment_id
93: and paa.business_group_id = v_bus_grp_id);
94:
95: cursor csr_del_entries_assignset(v_ben_start_date_id pay_input_values_f.input_value_id%type,
96: v_start_date VARCHAR2,
97: v_ben_end_date_id pay_input_values_f.input_value_id%type,
98: v_end_date VARCHAR2,
99: v_bus_grp_id pay_element_types_f.business_group_id%type,

Line 97: v_ben_end_date_id pay_input_values_f.input_value_id%type,

93: and paa.business_group_id = v_bus_grp_id);
94:
95: cursor csr_del_entries_assignset(v_ben_start_date_id pay_input_values_f.input_value_id%type,
96: v_start_date VARCHAR2,
97: v_ben_end_date_id pay_input_values_f.input_value_id%type,
98: v_end_date VARCHAR2,
99: v_bus_grp_id pay_element_types_f.business_group_id%type,
100: v_element_type_id pay_element_types_f.element_type_id%type,
101: v_assignment_set_id Number)