DBA Data[Home] [Help]

APPS.PAY_US_YEPP_MISS_ASSIGN_PKG dependencies on PAY_INPUT_VALUES_F

Line 419: pay_input_values_f piv

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'
422: and pet.classification_id = pec.classification_id
423: and pet.business_group_id = cp_business_group_id

Line 430: pay_input_values_f piv,

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,
434: pay_balance_attributes pba,

Line 483: lv_input_value_name PAY_INPUT_VALUES_F.NAME%TYPE;

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;
486: lv_legislation_code varchar2(100);
487: lv_element_info varchar2(200);