APPS.PAY_IP_EMPLOYEE_BALANCES dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 333: p_classification_name in pay_element_classifications.classification_name%TYPE,

329: b) ASG (Assignment level)
330: ******************************************************************************/
331: PROCEDURE populate_element_info( p_assignment_id in number,
332: p_assignment_action_id in number,
333: p_classification_name in pay_element_classifications.classification_name%TYPE,
334: p_session_date in pay_element_types_f.effective_start_date%TYPE,
335: p_tax_unit_id in number,
336: p_per_month in number,
337: p_per_qtd in number,

Line 383: FROM pay_element_classifications c

379: ******************************************************************************/
380:
381: CURSOR c_get_class_name (p_leg_code varchar2) IS
382: SELECT c.classification_id
383: FROM pay_element_classifications c
384: WHERE UPPER(c.classification_name) = UPPER(p_classification_name)
385: AND c.legislation_code = p_leg_code;
386:
387: /******************************************************************************

Line 669: FROM pay_element_classifications ec

665: SELECT DISTINCT pet2. element_name
666: ,pet2.element_type_id
667: ,pet2.classification_id
668: ,pet2.element_information10
669: FROM pay_element_classifications ec
670: ,pay_element_types_f et
671: ,pay_element_links_f el
672: ,pay_element_entries_f ee
673: ,pay_element_entry_values_f eev

Line 676: ,pay_element_classifications pec

672: ,pay_element_entries_f ee
673: ,pay_element_entry_values_f eev
674: ,pay_balance_feeds_f pbf
675: ,pay_element_types_f pet2
676: ,pay_element_classifications pec
677: ,pay_input_values_f piv
678: ,pay_balance_types pbt
679: WHERE ec.classification_name = 'Balance Initialization'
680: AND ec.legislation_code IS NULL

Line 713: FROM pay_element_classifications ec

709: ,pet2.classification_id
710: ,pet2.element_information10
711: ,pet2.element_information11
712: ,pet2.element_information13
713: FROM pay_element_classifications ec
714: ,pay_element_types_f et
715: ,pay_element_links_f el
716: ,pay_element_entries_f ee
717: ,pay_element_entry_values_f eev

Line 720: ,pay_element_classifications pec

716: ,pay_element_entries_f ee
717: ,pay_element_entry_values_f eev
718: ,pay_balance_feeds_f pbf
719: ,pay_element_types_f pet2
720: ,pay_element_classifications pec
721: ,pay_input_values_f piv
722: ,pay_balance_types pbt
723: WHERE ec.classification_name = 'Balance Initialization'
724: AND ec.legislation_code IS NULL