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

Line 199: from pay_element_classifications ec

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

Line 205: from pay_element_classifications ec2

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

Line 1995: from pay_element_classifications cl

1991: -- are allowed
1992: select cl.classification_id
1993: ,decode(cl.parent_classification_id, null,'N','Y')
1994: into v_classification_id, v_secondary_class
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: --