APPS.PAY_IP_EMPLOYEE_BALANCES dependencies on PAY_ELEMENT_TYPES_F

Line 47: (element_name pay_element_types_f.element_name%TYPE

43: ******************************************************************************/
44:
45: -- Record to store earning elements
46: TYPE earn_rec IS RECORD
47: (element_name pay_element_types_f.element_name%TYPE
48: ,element_type_id pay_element_types_f.element_type_id%TYPE
49: ,classification_id pay_element_types_f.classification_id%TYPE
50: ,element_information10 pay_element_types_f.element_information10%TYPE);
51:

Line 48: ,element_type_id pay_element_types_f.element_type_id%TYPE

44:
45: -- Record to store earning elements
46: TYPE earn_rec IS RECORD
47: (element_name pay_element_types_f.element_name%TYPE
48: ,element_type_id pay_element_types_f.element_type_id%TYPE
49: ,classification_id pay_element_types_f.classification_id%TYPE
50: ,element_information10 pay_element_types_f.element_information10%TYPE);
51:
52: -- Record to store deduction elements

Line 49: ,classification_id pay_element_types_f.classification_id%TYPE

45: -- Record to store earning elements
46: TYPE earn_rec IS RECORD
47: (element_name pay_element_types_f.element_name%TYPE
48: ,element_type_id pay_element_types_f.element_type_id%TYPE
49: ,classification_id pay_element_types_f.classification_id%TYPE
50: ,element_information10 pay_element_types_f.element_information10%TYPE);
51:
52: -- Record to store deduction elements
53: TYPE dedn_rec IS RECORD

Line 50: ,element_information10 pay_element_types_f.element_information10%TYPE);

46: TYPE earn_rec IS RECORD
47: (element_name pay_element_types_f.element_name%TYPE
48: ,element_type_id pay_element_types_f.element_type_id%TYPE
49: ,classification_id pay_element_types_f.classification_id%TYPE
50: ,element_information10 pay_element_types_f.element_information10%TYPE);
51:
52: -- Record to store deduction elements
53: TYPE dedn_rec IS RECORD
54: (element_name pay_element_types_f.element_name%TYPE

Line 54: (element_name pay_element_types_f.element_name%TYPE

50: ,element_information10 pay_element_types_f.element_information10%TYPE);
51:
52: -- Record to store deduction elements
53: TYPE dedn_rec IS RECORD
54: (element_name pay_element_types_f.element_name%TYPE
55: ,element_type_id pay_element_types_f.element_type_id%TYPE
56: ,classification_id pay_element_types_f.classification_id%TYPE
57: ,element_information10 pay_element_types_f.element_information10%TYPE
58: ,element_information11 pay_element_types_f.element_information11%TYPE

Line 55: ,element_type_id pay_element_types_f.element_type_id%TYPE

51:
52: -- Record to store deduction elements
53: TYPE dedn_rec IS RECORD
54: (element_name pay_element_types_f.element_name%TYPE
55: ,element_type_id pay_element_types_f.element_type_id%TYPE
56: ,classification_id pay_element_types_f.classification_id%TYPE
57: ,element_information10 pay_element_types_f.element_information10%TYPE
58: ,element_information11 pay_element_types_f.element_information11%TYPE
59: ,element_information13 pay_element_types_f.element_information13%TYPE);

Line 56: ,classification_id pay_element_types_f.classification_id%TYPE

52: -- Record to store deduction elements
53: TYPE dedn_rec IS RECORD
54: (element_name pay_element_types_f.element_name%TYPE
55: ,element_type_id pay_element_types_f.element_type_id%TYPE
56: ,classification_id pay_element_types_f.classification_id%TYPE
57: ,element_information10 pay_element_types_f.element_information10%TYPE
58: ,element_information11 pay_element_types_f.element_information11%TYPE
59: ,element_information13 pay_element_types_f.element_information13%TYPE);
60:

Line 57: ,element_information10 pay_element_types_f.element_information10%TYPE

53: TYPE dedn_rec IS RECORD
54: (element_name pay_element_types_f.element_name%TYPE
55: ,element_type_id pay_element_types_f.element_type_id%TYPE
56: ,classification_id pay_element_types_f.classification_id%TYPE
57: ,element_information10 pay_element_types_f.element_information10%TYPE
58: ,element_information11 pay_element_types_f.element_information11%TYPE
59: ,element_information13 pay_element_types_f.element_information13%TYPE);
60:
61:

Line 58: ,element_information11 pay_element_types_f.element_information11%TYPE

54: (element_name pay_element_types_f.element_name%TYPE
55: ,element_type_id pay_element_types_f.element_type_id%TYPE
56: ,classification_id pay_element_types_f.classification_id%TYPE
57: ,element_information10 pay_element_types_f.element_information10%TYPE
58: ,element_information11 pay_element_types_f.element_information11%TYPE
59: ,element_information13 pay_element_types_f.element_information13%TYPE);
60:
61:
62: -- Declare tables for records

Line 59: ,element_information13 pay_element_types_f.element_information13%TYPE);

55: ,element_type_id pay_element_types_f.element_type_id%TYPE
56: ,classification_id pay_element_types_f.classification_id%TYPE
57: ,element_information10 pay_element_types_f.element_information10%TYPE
58: ,element_information11 pay_element_types_f.element_information11%TYPE
59: ,element_information13 pay_element_types_f.element_information13%TYPE);
60:
61:
62: -- Declare tables for records
63: TYPE earn_tbl IS TABLE OF

Line 70: ( ele_name pay_element_types_f.element_name%TYPE,

66: TYPE dedn_tbl IS TABLE OF
67: dedn_rec INDEX BY BINARY_INTEGER;
68:
69: TYPE rec_entity_details IS RECORD
70: ( ele_name pay_element_types_f.element_name%TYPE,
71: ele_type_id pay_element_types_f.element_type_id%TYPE,
72: def_bal_id pay_defined_balances.defined_balance_id%TYPE,
73: bal_value NUMBER,
74: bal_type_id pay_balance_types.balance_type_id%TYPE,

Line 71: ele_type_id pay_element_types_f.element_type_id%TYPE,

67: dedn_rec INDEX BY BINARY_INTEGER;
68:
69: TYPE rec_entity_details IS RECORD
70: ( ele_name pay_element_types_f.element_name%TYPE,
71: ele_type_id pay_element_types_f.element_type_id%TYPE,
72: def_bal_id pay_defined_balances.defined_balance_id%TYPE,
73: bal_value NUMBER,
74: bal_type_id pay_balance_types.balance_type_id%TYPE,
75: bal_dim_id pay_balance_dimensions.balance_dimension_id%TYPE,

Line 82: ( ele_name pay_element_types_f.element_name%TYPE,

78: TYPE entity_details_tab IS TABLE OF rec_entity_details INDEX BY BINARY_INTEGER;
79: t_defbal_details_tab entity_details_tab;
80:
81: TYPE ele_bal_details_rec IS RECORD
82: ( ele_name pay_element_types_f.element_name%TYPE,
83: ele_type_id pay_element_types_f.element_type_id%TYPE,
84: bal_type_id pay_balance_types.balance_type_id%TYPE,
85: ptd_bal_dim_id pay_balance_dimensions.balance_dimension_id%TYPE,
86: ptd_bal_value NUMBER,

Line 83: ele_type_id pay_element_types_f.element_type_id%TYPE,

79: t_defbal_details_tab entity_details_tab;
80:
81: TYPE ele_bal_details_rec IS RECORD
82: ( ele_name pay_element_types_f.element_name%TYPE,
83: ele_type_id pay_element_types_f.element_type_id%TYPE,
84: bal_type_id pay_balance_types.balance_type_id%TYPE,
85: ptd_bal_dim_id pay_balance_dimensions.balance_dimension_id%TYPE,
86: ptd_bal_value NUMBER,
87: mtd_bal_dim_id pay_balance_dimensions.balance_dimension_id%TYPE,

Line 127: p_session_date in pay_element_types_f.effective_start_date%TYPE,

123: ******************************************************************************/
124: PROCEDURE populate_element_info( p_assignment_id in number,
125: p_assignment_action_id in number,
126: p_classification_name in pay_element_classifications.classification_name%TYPE,
127: p_session_date in pay_element_types_f.effective_start_date%TYPE,
128: p_tax_unit_id in number,
129: p_per_month in number,
130: p_per_qtd in number,
131: p_per_ytd in number,

Line 138: p_business_group_id in pay_element_types_f.business_group_id%TYPE,

134: p_asg_qtd in number,
135: p_asg_ytd in number,
136: p_asg_arr_itd in number,
137: p_asg_acc_itd in number,
138: p_business_group_id in pay_element_types_f.business_group_id%TYPE,
139: p_balance_level in varchar2
140: );
141:
142: END pay_ip_employee_balances;