DBA Data[Home] [Help]

APPS.PAY_CA_T4AEOY_ARCHIVE dependencies on PAY_BALANCE_TYPES

Line 1845: pay_balance_types pbt,

1841: cursor c_balance_feed_info (p_balance_name varchar2) is
1842: select distinct pet.element_information18,
1843: pbt1.balance_name
1844: from pay_balance_feeds_f pbf,
1845: pay_balance_types pbt,
1846: pay_balance_types pbt1,
1847: pay_input_values_f piv,
1848: pay_element_types_f pet,
1849: fnd_lookup_values flv

Line 1846: pay_balance_types pbt1,

1842: select distinct pet.element_information18,
1843: pbt1.balance_name
1844: from pay_balance_feeds_f pbf,
1845: pay_balance_types pbt,
1846: pay_balance_types pbt1,
1847: pay_input_values_f piv,
1848: pay_element_types_f pet,
1849: fnd_lookup_values flv
1850: where pbt.balance_name = p_balance_name

Line 1867: pay_balance_types pbt,

1863: select nvl(pet.element_information20,'NOT FOUND'),
1864: pbt1.balance_name,pet.element_type_id,
1865: pet.classification_id
1866: from pay_balance_feeds_f pbf,
1867: pay_balance_types pbt,
1868: pay_balance_types pbt1,
1869: pay_input_values_f piv,
1870: pay_element_types_f pet
1871: where pbt.balance_name = p_balance_name

Line 1868: pay_balance_types pbt1,

1864: pbt1.balance_name,pet.element_type_id,
1865: pet.classification_id
1866: from pay_balance_feeds_f pbf,
1867: pay_balance_types pbt,
1868: pay_balance_types pbt1,
1869: pay_input_values_f piv,
1870: pay_element_types_f pet
1871: where pbt.balance_name = p_balance_name
1872: and pbf.balance_type_id = pbt.balance_type_id