[Home] [Help]
245: , pay_element_classifications pec
246: , pay_defined_balances pdb
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
331: , pay_element_classifications pec
332: , pay_defined_balances pdb
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
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
422: AND PAA.ASSIGNMENT_ACTION_ID =p_assignment_action_id
423: and paa.payroll_action_id =ppa.payroll_action_id
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'
512: and ec.legislation_code is null
513: and ee.assignment_id = p_assignment_id
514: and ee.element_link_id = el.element_link_id
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:
545:
546: /******************************************************************************
551: FUNCTION get_balance_name(l_balance_type_id in number )
552: RETURN varchar2 IS
553: BEGIN
554: SELECT balance_name INTO value
555: FROM pay_balance_types
556: WHERE balance_type_id =l_balance_type_id;
557: RETURN value;
558:
559: EXCEPTION WHEN NO_DATA_FOUND THEN