DBA Data[Home] [Help]

APPS.PQP_GB_MILEAGE_CLAIM_PKG dependencies on PAY_ELEMENT_TYPES_F_TL

Line 516: FROM pay_element_types_f_tl elementtl,

512: IS
513: SELECT element.element_type_id
514: , elementtl.element_name
515: ,link.element_link_id
516: FROM pay_element_types_f_tl elementtl,
517: pay_element_types_f element,
518: pay_element_links_f link,
519: per_all_assignments_f asgt ,
520: pay_element_type_extra_info pete,

Line 638: FROM pay_element_types_f_tl elementtl,

634: ,cp_sl_rate_type VARCHAR2
635: )
636: IS
637: SELECT element.element_type_id , elementtl.element_name
638: FROM pay_element_types_f_tl elementtl,
639: pay_element_types_f element,
640: pay_element_links_f link,
641: per_all_assignments_f asgt ,
642: pay_element_type_extra_info pete,

Line 2478: from pay_element_types_f_tl

2474: --
2475: CURSOR c_get_element_name
2476: IS
2477: select element_name
2478: from pay_element_types_f_tl
2479: where element_type_id = p_field_id;
2480:
2481: --
2482: -- Cursor to fetch the Rates Table Name given the rates table id