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 2464: from pay_element_types_f_tl

2460: --
2461: CURSOR c_get_element_name
2462: IS
2463: select element_name
2464: from pay_element_types_f_tl
2465: where element_type_id = p_field_id;
2466:
2467: --
2468: -- Cursor to fetch the Rates Table Name given the rates table id