eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_CA_T4AEOY_ARCHIVE dependencies on PAY_BALANCE_TYPES

Line 1976: pay_balance_types pbt,

1972: cursor c_balance_feed_info (p_balance_name varchar2) is
1973: select distinct pet.element_information18,
1974: pbt1.balance_name
1975: from pay_balance_feeds_f pbf,
1976: pay_balance_types pbt,
1977: pay_balance_types pbt1,
1978: pay_input_values_f piv,
1979: pay_element_types_f pet,
1980: fnd_lookup_values flv

Line 1977: pay_balance_types pbt1,

1973: select distinct pet.element_information18,
1974: pbt1.balance_name
1975: from pay_balance_feeds_f pbf,
1976: pay_balance_types pbt,
1977: pay_balance_types pbt1,
1978: pay_input_values_f piv,
1979: pay_element_types_f pet,
1980: fnd_lookup_values flv
1981: where pbt.balance_name = p_balance_name

Line 1998: pay_balance_types pbt,

1994: select distinct nvl(pet.element_information20,'NOT FOUND'),
1995: pbt1.balance_name,pet.element_type_id,
1996: pet.classification_id
1997: from pay_balance_feeds_f pbf,
1998: pay_balance_types pbt,
1999: pay_balance_types pbt1,
2000: pay_input_values_f piv,
2001: pay_element_types_f pet
2002: where pbt.balance_name = p_balance_name

Line 1999: pay_balance_types pbt1,

1995: pbt1.balance_name,pet.element_type_id,
1996: pet.classification_id
1997: from pay_balance_feeds_f pbf,
1998: pay_balance_types pbt,
1999: pay_balance_types pbt1,
2000: pay_input_values_f piv,
2001: pay_element_types_f pet
2002: where pbt.balance_name = p_balance_name
2003: and pbf.balance_type_id = pbt.balance_type_id

Line 3389: pay_balance_types pbt,

3385: cursor c_balance_feed_info (p_balance_name varchar2) is
3386: select distinct pet.element_information18,
3387: pbt1.balance_name
3388: from pay_balance_feeds_f pbf,
3389: pay_balance_types pbt,
3390: pay_balance_types pbt1,
3391: pay_input_values_f piv,
3392: pay_element_types_f pet,
3393: fnd_lookup_values flv

Line 3390: pay_balance_types pbt1,

3386: select distinct pet.element_information18,
3387: pbt1.balance_name
3388: from pay_balance_feeds_f pbf,
3389: pay_balance_types pbt,
3390: pay_balance_types pbt1,
3391: pay_input_values_f piv,
3392: pay_element_types_f pet,
3393: fnd_lookup_values flv
3394: where pbt.balance_name = p_balance_name

Line 3411: pay_balance_types pbt,

3407: select distinct nvl(pet.element_information20,'NOT FOUND'),
3408: pbt1.balance_name,pet.element_type_id,
3409: pet.classification_id
3410: from pay_balance_feeds_f pbf,
3411: pay_balance_types pbt,
3412: pay_balance_types pbt1,
3413: pay_input_values_f piv,
3414: pay_element_types_f pet
3415: where pbt.balance_name = p_balance_name

Line 3412: pay_balance_types pbt1,

3408: pbt1.balance_name,pet.element_type_id,
3409: pet.classification_id
3410: from pay_balance_feeds_f pbf,
3411: pay_balance_types pbt,
3412: pay_balance_types pbt1,
3413: pay_input_values_f piv,
3414: pay_element_types_f pet
3415: where pbt.balance_name = p_balance_name
3416: and pbf.balance_type_id = pbt.balance_type_id