DBA Data[Home] [Help]

APPS.PAY_US_EMPLOYEE_BALANCES dependencies on PAY_ELEMENT_TYPES_F

Line 48: ,element_name pay_element_types_f.element_name%TYPE

44:
45: -- Record to store earning elements
46: TYPE earn_rec IS RECORD
47: (row_id ROWID
48: ,element_name pay_element_types_f.element_name%TYPE
49: ,ptd number
50: ,month number
51: ,qtd number
52: ,ytd number

Line 53: ,element_type_id pay_element_types_f.element_type_id%TYPE

49: ,ptd number
50: ,month number
51: ,qtd number
52: ,ytd number
53: ,element_type_id pay_element_types_f.element_type_id%TYPE
54: ,classification_id pay_element_types_f.classification_id%TYPE
55: ,element_information10 pay_element_types_f.element_information10%TYPE
56: ,element_information11 pay_element_types_f.element_information11%TYPE
57: ,element_information12 pay_element_types_f.element_information12%TYPE

Line 54: ,classification_id pay_element_types_f.classification_id%TYPE

50: ,month number
51: ,qtd number
52: ,ytd number
53: ,element_type_id pay_element_types_f.element_type_id%TYPE
54: ,classification_id pay_element_types_f.classification_id%TYPE
55: ,element_information10 pay_element_types_f.element_information10%TYPE
56: ,element_information11 pay_element_types_f.element_information11%TYPE
57: ,element_information12 pay_element_types_f.element_information12%TYPE
58: ,element_information14 pay_element_types_f.element_information14%TYPE

Line 55: ,element_information10 pay_element_types_f.element_information10%TYPE

51: ,qtd number
52: ,ytd number
53: ,element_type_id pay_element_types_f.element_type_id%TYPE
54: ,classification_id pay_element_types_f.classification_id%TYPE
55: ,element_information10 pay_element_types_f.element_information10%TYPE
56: ,element_information11 pay_element_types_f.element_information11%TYPE
57: ,element_information12 pay_element_types_f.element_information12%TYPE
58: ,element_information14 pay_element_types_f.element_information14%TYPE
59: );

Line 56: ,element_information11 pay_element_types_f.element_information11%TYPE

52: ,ytd number
53: ,element_type_id pay_element_types_f.element_type_id%TYPE
54: ,classification_id pay_element_types_f.classification_id%TYPE
55: ,element_information10 pay_element_types_f.element_information10%TYPE
56: ,element_information11 pay_element_types_f.element_information11%TYPE
57: ,element_information12 pay_element_types_f.element_information12%TYPE
58: ,element_information14 pay_element_types_f.element_information14%TYPE
59: );
60:

Line 57: ,element_information12 pay_element_types_f.element_information12%TYPE

53: ,element_type_id pay_element_types_f.element_type_id%TYPE
54: ,classification_id pay_element_types_f.classification_id%TYPE
55: ,element_information10 pay_element_types_f.element_information10%TYPE
56: ,element_information11 pay_element_types_f.element_information11%TYPE
57: ,element_information12 pay_element_types_f.element_information12%TYPE
58: ,element_information14 pay_element_types_f.element_information14%TYPE
59: );
60:
61:

Line 58: ,element_information14 pay_element_types_f.element_information14%TYPE

54: ,classification_id pay_element_types_f.classification_id%TYPE
55: ,element_information10 pay_element_types_f.element_information10%TYPE
56: ,element_information11 pay_element_types_f.element_information11%TYPE
57: ,element_information12 pay_element_types_f.element_information12%TYPE
58: ,element_information14 pay_element_types_f.element_information14%TYPE
59: );
60:
61:
62: -- Record to store deduction elements

Line 65: ,element_name pay_element_types_f.element_name%TYPE

61:
62: -- Record to store deduction elements
63: TYPE dedn_rec IS RECORD
64: (row_id ROWID
65: ,element_name pay_element_types_f.element_name%TYPE
66: ,ptd number
67: ,month number
68: ,qtd number
69: ,ytd number

Line 73: ,element_type_id pay_element_types_f.element_type_id%TYPE

69: ,ytd number
70: ,accrued number
71: ,arrears number
72: ,tobond number
73: ,element_type_id pay_element_types_f.element_type_id%TYPE
74: ,classification_id pay_element_types_f.classification_id%TYPE
75: ,element_information10 pay_element_types_f.element_information10%TYPE
76: ,element_information11 pay_element_types_f.element_information11%TYPE
77: ,element_information12 pay_element_types_f.element_information12%TYPE

Line 74: ,classification_id pay_element_types_f.classification_id%TYPE

70: ,accrued number
71: ,arrears number
72: ,tobond number
73: ,element_type_id pay_element_types_f.element_type_id%TYPE
74: ,classification_id pay_element_types_f.classification_id%TYPE
75: ,element_information10 pay_element_types_f.element_information10%TYPE
76: ,element_information11 pay_element_types_f.element_information11%TYPE
77: ,element_information12 pay_element_types_f.element_information12%TYPE
78: ,element_information14 pay_element_types_f.element_information14%TYPE

Line 75: ,element_information10 pay_element_types_f.element_information10%TYPE

71: ,arrears number
72: ,tobond number
73: ,element_type_id pay_element_types_f.element_type_id%TYPE
74: ,classification_id pay_element_types_f.classification_id%TYPE
75: ,element_information10 pay_element_types_f.element_information10%TYPE
76: ,element_information11 pay_element_types_f.element_information11%TYPE
77: ,element_information12 pay_element_types_f.element_information12%TYPE
78: ,element_information14 pay_element_types_f.element_information14%TYPE
79: );

Line 76: ,element_information11 pay_element_types_f.element_information11%TYPE

72: ,tobond number
73: ,element_type_id pay_element_types_f.element_type_id%TYPE
74: ,classification_id pay_element_types_f.classification_id%TYPE
75: ,element_information10 pay_element_types_f.element_information10%TYPE
76: ,element_information11 pay_element_types_f.element_information11%TYPE
77: ,element_information12 pay_element_types_f.element_information12%TYPE
78: ,element_information14 pay_element_types_f.element_information14%TYPE
79: );
80:

Line 77: ,element_information12 pay_element_types_f.element_information12%TYPE

73: ,element_type_id pay_element_types_f.element_type_id%TYPE
74: ,classification_id pay_element_types_f.classification_id%TYPE
75: ,element_information10 pay_element_types_f.element_information10%TYPE
76: ,element_information11 pay_element_types_f.element_information11%TYPE
77: ,element_information12 pay_element_types_f.element_information12%TYPE
78: ,element_information14 pay_element_types_f.element_information14%TYPE
79: );
80:
81:

Line 78: ,element_information14 pay_element_types_f.element_information14%TYPE

74: ,classification_id pay_element_types_f.classification_id%TYPE
75: ,element_information10 pay_element_types_f.element_information10%TYPE
76: ,element_information11 pay_element_types_f.element_information11%TYPE
77: ,element_information12 pay_element_types_f.element_information12%TYPE
78: ,element_information14 pay_element_types_f.element_information14%TYPE
79: );
80:
81:
82: -- Declare tables for records

Line 109: p_session_date in pay_element_types_f.effective_start_date%TYPE,

105: PROCEDURE populate_element_info( p_assignment_id in number,
106: p_assignment_action_id in number,
107: p_classification_id in pay_element_classifications.classification_id%TYPE,
108: p_classification_name in pay_element_classifications.classification_name%TYPE,
109: p_session_date in pay_element_types_f.effective_start_date%TYPE,
110: p_action_date in pay_element_types_f.effective_start_date%TYPE,
111: p_pay_start_date in pay_element_types_f.effective_start_date%TYPE,
112: p_tax_unit_id in number,
113: p_per_month in number,

Line 110: p_action_date in pay_element_types_f.effective_start_date%TYPE,

106: p_assignment_action_id in number,
107: p_classification_id in pay_element_classifications.classification_id%TYPE,
108: p_classification_name in pay_element_classifications.classification_name%TYPE,
109: p_session_date in pay_element_types_f.effective_start_date%TYPE,
110: p_action_date in pay_element_types_f.effective_start_date%TYPE,
111: p_pay_start_date in pay_element_types_f.effective_start_date%TYPE,
112: p_tax_unit_id in number,
113: p_per_month in number,
114: p_per_qtd in number,

Line 111: p_pay_start_date in pay_element_types_f.effective_start_date%TYPE,

107: p_classification_id in pay_element_classifications.classification_id%TYPE,
108: p_classification_name in pay_element_classifications.classification_name%TYPE,
109: p_session_date in pay_element_types_f.effective_start_date%TYPE,
110: p_action_date in pay_element_types_f.effective_start_date%TYPE,
111: p_pay_start_date in pay_element_types_f.effective_start_date%TYPE,
112: p_tax_unit_id in number,
113: p_per_month in number,
114: p_per_qtd in number,
115: p_per_ytd in number,

Line 121: p_legislation_code in pay_element_types_f.legislation_code%TYPE,

117: p_asg_month in number,
118: p_asg_qtd in number,
119: p_asg_ytd in number,
120: p_asg_itd in number,
121: p_legislation_code in pay_element_types_f.legislation_code%TYPE,
122: p_business_group_id in pay_element_types_f.business_group_id%TYPE,
123: p_balance_level in varchar2,
124: p_earn_data out nocopy earn_tbl,
125: p_dedn_data out nocopy dedn_tbl,

Line 122: p_business_group_id in pay_element_types_f.business_group_id%TYPE,

118: p_asg_qtd in number,
119: p_asg_ytd in number,
120: p_asg_itd in number,
121: p_legislation_code in pay_element_types_f.legislation_code%TYPE,
122: p_business_group_id in pay_element_types_f.business_group_id%TYPE,
123: p_balance_level in varchar2,
124: p_earn_data out nocopy earn_tbl,
125: p_dedn_data out nocopy dedn_tbl,
126: p_element_type_id in out nocopy number,