[Home] [Help]
91: PROCEDURE populate_element_info( p_assignment_id in number,
92: p_assignment_action_id in number,
93: p_classification_id in pay_element_classifications.classification_id%TYPE,
94: p_classification_name in pay_element_classifications.classification_name%TYPE,
95: p_session_date in pay_element_types_f.effective_start_date%TYPE,
96: p_action_date in pay_element_types_f.effective_start_date%TYPE,
97: p_pay_start_date in pay_element_types_f.effective_start_date%TYPE,
98: p_tax_unit_id in number,
99: p_per_month in number,
92: p_assignment_action_id in number,
93: p_classification_id in pay_element_classifications.classification_id%TYPE,
94: p_classification_name in pay_element_classifications.classification_name%TYPE,
95: p_session_date in pay_element_types_f.effective_start_date%TYPE,
96: p_action_date in pay_element_types_f.effective_start_date%TYPE,
97: p_pay_start_date in pay_element_types_f.effective_start_date%TYPE,
98: p_tax_unit_id in number,
99: p_per_month in number,
100: p_per_qtd in number,
93: p_classification_id in pay_element_classifications.classification_id%TYPE,
94: p_classification_name in pay_element_classifications.classification_name%TYPE,
95: p_session_date in pay_element_types_f.effective_start_date%TYPE,
96: p_action_date in pay_element_types_f.effective_start_date%TYPE,
97: p_pay_start_date in pay_element_types_f.effective_start_date%TYPE,
98: p_tax_unit_id in number,
99: p_per_month in number,
100: p_per_qtd in number,
101: p_per_ytd in number,
103: p_asg_month in number,
104: p_asg_qtd in number,
105: p_asg_ytd in number,
106: p_asg_itd in number,
107: p_legislation_code in pay_element_types_f.legislation_code%TYPE,
108: p_business_group_id in pay_element_types_f.business_group_id%TYPE,
109: p_balance_level in varchar2,
110: p_earn_data out nocopy earn_tbl,
111: p_dedn_data out nocopy dedn_tbl,
104: p_asg_qtd in number,
105: p_asg_ytd in number,
106: p_asg_itd in number,
107: p_legislation_code in pay_element_types_f.legislation_code%TYPE,
108: p_business_group_id in pay_element_types_f.business_group_id%TYPE,
109: p_balance_level in varchar2,
110: p_earn_data out nocopy earn_tbl,
111: p_dedn_data out nocopy dedn_tbl,
112: p_element_type_id in out nocopy number,
165: ,pet.element_information10
166: ,pet.element_information11
167: ,pet.element_information12
168: ,pet.element_information14
169: from pay_element_types_f pet
170: , pay_element_types_f pet2
171: , pay_element_entries_f ee
172: WHERE pet2.classification_id = p_classification_id
173: AND pet2.element_information10 is not null
166: ,pet.element_information11
167: ,pet.element_information12
168: ,pet.element_information14
169: from pay_element_types_f pet
170: , pay_element_types_f pet2
171: , pay_element_entries_f ee
172: WHERE pet2.classification_id = p_classification_id
173: AND pet2.element_information10 is not null
174: AND ee.effective_end_date >= p_pay_start_date
175: AND ee.effective_start_date <= nvl(p_action_date , p_session_date )
176: AND ee.effective_start_date between pet2.effective_start_date and pet2.effective_end_date
177: AND pet2.element_type_id = pet.element_type_id
178: AND PET.effective_start_date = (select max(pet1.effective_start_date)
179: from pay_element_types_f pet1
180: where pet1.element_type_id = pet.element_type_id
181: and pet1.effective_start_date <= p_session_date )
182: AND pet.element_name not like 'VERTEX%'
183: AND ee.assignment_id = p_assignment_id
198: ******************************************************************************/
199:
200: CURSOR csr_element_assact_info
201: IS
202: select /*+ index (pet pay_element_types_f_fk1) */ distinct pet.rowid
203: ,pet.element_name
204: ,pet.element_type_id
205: ,pet.classification_id
206: ,pet.element_information10
240: NULL ,
241: p_tax_unit_id,--control.tax_unit_id
242: p_business_group_id ,--ctlglobals.bg_id
243: NULL) YTD_VAL
244: from pay_element_types_f pet
245: , pay_element_classifications pec
246: , pay_defined_balances pdb
247: , pay_bal_attribute_definitions pbad
248: , pay_balance_attributes pba
284: ******************************************************************************/
285:
286: CURSOR csr_element_assact_info_dedn
287: IS
288: select /*+ index (pet pay_element_types_f_fk1) */ distinct pet.rowid
289: ,pet.element_name
290: ,pet.element_type_id
291: ,pet.classification_id
292: ,pet.element_information10
326: NULL ,
327: p_tax_unit_id,--control.tax_unit_id
328: p_business_group_id ,--ctlglobals.bg_id
329: NULL) YTD_VAL
330: from pay_element_types_f pet
331: , pay_element_classifications pec
332: , pay_defined_balances pdb
333: , pay_bal_attribute_definitions pbad
334: , pay_balance_attributes pba
412: NULL ,
413: p_tax_unit_id,--control.tax_unit_id
414: p_business_group_id ,--ctlglobals.bg_id
415: NULL) YTD_VAL
416: from pay_element_types_f pet
417: , pay_payroll_actions ppa
418: , pay_assignment_actions paa
419: , pay_balance_types pbt
420: WHERE pet.classification_id = p_classification_id
498: p_tax_unit_id,--control.tax_unit_id
499: p_business_group_id ,--ctlglobals.bg_id
500: NULL) YTD_VAL
501: from pay_element_classifications ec
502: ,pay_element_types_f et
503: ,pay_element_links_f el
504: ,pay_element_entries_f ee
505: ,pay_element_entry_values_f eev
506: ,pay_balance_feeds_f pbf
503: ,pay_element_links_f el
504: ,pay_element_entries_f ee
505: ,pay_element_entry_values_f eev
506: ,pay_balance_feeds_f pbf
507: ,pay_element_types_f pet2
508: ,pay_element_classifications pec
509: ,pay_input_values_f piv
510: ,pay_balance_types pbt
511: where ec.classification_name = 'Balance Initialization'