APPS.PAY_US_YEPP_MISS_ASSIGN_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 417: from pay_element_types_f pet,

413: cp_legislation_code VARCHAR2
414: )
415: IS
416: select distinct element_name, classification_name,piv.name
417: from pay_element_types_f pet,
418: pay_element_classifications pec,
419: pay_input_values_f piv
420: where pet.element_type_id = piv.element_type_id
421: and piv.uom = 'M'

Line 429: from pay_element_types_f pet,

425: pec.business_group_id = cp_business_group_id)
426: and piv.input_value_id not in
427: (
428: select distinct piv.input_value_id
429: from pay_element_types_f pet,
430: pay_input_values_f piv,
431: pay_balance_feeds_f pbf,
432: pay_balance_types pbt,
433: pay_defined_balances pdb,

Line 481: lv_element_name PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE;

477: lv_output_file_type VARCHAR2(100);
478:
479: lv_title VARCHAR2(1000);
480: lv_header_label VARCHAR2(1000);
481: lv_element_name PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE;
482: lv_classification_name PAY_ELEMENT_CLASSIFICATIONS.CLASSIFICATION_NAME%TYPE;
483: lv_input_value_name PAY_INPUT_VALUES_F.NAME%TYPE;
484: lv_element_row VARCHAR2(1000);
485: lv_element_count NUMBER;