[Home] [Help]
123: CURSOR c_action_type
124: IS
125: select pay.action_type
126: from pay_assignment_actions pac
127: ,pay_payroll_actions pay
128: where pay.payroll_action_id = pac.payroll_action_id
129: and pac.assignment_id = p_assignment_id
130: and pac.action_status = 'C'
131: and pac.tax_unit_id = p_tax_unit_id
247: , pay_bal_attribute_definitions pbad
248: , pay_balance_attributes pba
249: , pay_balance_types pbt
250: , pay_assignment_actions paa
251: , pay_payroll_actions ppa
252: WHERE pbad.attribute_name = l_attribute_name
253: AND pbad.business_group_id is null
254: AND pbad.legislation_code = 'US'
255: AND pba.attribute_id = pbad.attribute_id
333: , pay_bal_attribute_definitions pbad
334: , pay_balance_attributes pba
335: , pay_balance_types pbt
336: , pay_assignment_actions paa
337: , pay_payroll_actions ppa
338: WHERE pbad.attribute_name = l_attribute_name
339: AND pbad.business_group_id is null
340: AND pbad.legislation_code = 'US'
341: AND pba.attribute_id = pbad.attribute_id
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
421: AND pet.element_information10 is not null
426: AND pet.element_name not like 'VERTEX%'
427: AND paa.assignment_id = p_assignment_id
428: AND pet.element_information10 =pbt.balance_type_id
429: AND EXISTS (SELECT 'x'
430: FROM pay_payroll_actions pact,
431: pay_assignment_actions asg,
432: pay_run_results rr
433: where rr.element_type_id + 0 = pet.element_type_id
434: and rr.assignment_action_id = asg.assignment_action_id
536: end_cnt number;
537: i number;
538: j number;
539: l_value number;
540: l_type pay_payroll_actions.action_type%TYPE;
541: l_procedure VARCHAR2(22) ;
542: value pay_balance_types.balance_name%type ;
543: p_dedn_data_temp p_dedn_data_temp_tbl;
544: