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_DB_PAY_SETUP dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 200: from pay_element_classifications ec

196: ec.non_payments_flag
197: into v_classification_id,
198: v_processing_priority,
199: v_non_payments_flag
200: from pay_element_classifications ec
201: where upper(ec.classification_name) = upper(p_classification_name)
202: and ec.parent_classification_id is NULL
203: and ((ec.legislation_code = v_legislation_code)
204: or (ec.legislation_code is null

Line 206: from pay_element_classifications ec2

202: and ec.parent_classification_id is NULL
203: and ((ec.legislation_code = v_legislation_code)
204: or (ec.legislation_code is null
205: and not exists (select ''
206: from pay_element_classifications ec2
207: where upper(ec2.classification_name) = upper(p_classification_name)
208: and ec2.parent_classification_id is NULL
209: and ec2.legislation_code = v_legislation_code)
210: ));

Line 1995: from pay_element_classifications cl

1991: -- Find the classification for the balance NB. only primary classifications
1992: -- are allowed
1993: select cl.classification_id
1994: into v_classification_id
1995: from pay_element_classifications cl
1996: where upper(cl.classification_name) = upper(p_balance_classification)
1997: and cl.parent_classification_id is NULL
1998: and cl.legislation_code = v_legislation_code;
1999: --