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_US_ACTION_ARCH dependencies on PAY_ELEMENT_TYPES_F

Line 6264: pay_element_types_f pet,

6260: pay_pre_payments ppp,
6261: pay_input_values_f piv_pay,
6262: pay_run_result_values prrv_att,
6263: pay_run_result_values prrv_pay,
6264: pay_element_types_f pet,
6265: pay_element_types_f pet_calc,
6266: pay_element_classifications pec
6267: where round(ppp.value ,2) = round(p_value ,2)
6268: and ppp.pre_payment_id = p_pre_payment_id

Line 6265: pay_element_types_f pet_calc,

6261: pay_input_values_f piv_pay,
6262: pay_run_result_values prrv_att,
6263: pay_run_result_values prrv_pay,
6264: pay_element_types_f pet,
6265: pay_element_types_f pet_calc,
6266: pay_element_classifications pec
6267: where round(ppp.value ,2) = round(p_value ,2)
6268: and ppp.pre_payment_id = p_pre_payment_id
6269: and ppp.assignment_action_id = pai.locking_action_id

Line 6406: pay_element_types_f pet,

6402: select prrv.result_value
6403: from pay_run_results prr,
6404: pay_run_result_values prrv,
6405: pay_input_values_f piv,
6406: pay_element_types_f pet,
6407: pay_element_types_f pet1
6408: where prr.assignment_action_id = ass_act_id and
6409: pet1.element_type_id = ele_type_id and
6410: pet.element_name = pet1.element_name ||' Calculator' and

Line 6407: pay_element_types_f pet1

6403: from pay_run_results prr,
6404: pay_run_result_values prrv,
6405: pay_input_values_f piv,
6406: pay_element_types_f pet,
6407: pay_element_types_f pet1
6408: where prr.assignment_action_id = ass_act_id and
6409: pet1.element_type_id = ele_type_id and
6410: pet.element_name = pet1.element_name ||' Calculator' and
6411: prr.element_type_id = pet.element_type_id and

Line 6453: pay_element_types_f pet,

6449: pay_assignment_actions paa,
6450: pay_action_interlocks pai,
6451: pay_pre_payments ppp,
6452: pay_run_result_values prrv_att,
6453: pay_element_types_f pet,
6454: pay_element_classifications pec
6455: WHERE round(ppp.value ,2) = round(p_value ,2)
6456: and ppp.pre_payment_id = p_pre_payment_id
6457: and ppp.assignment_action_id = pai.locking_action_id

Line 6488: from pay_element_types_f petf_calc,

6484: and pec.business_group_id IS NULL;
6485:
6486: cursor upgrade_date (ele_type_id number) is
6487: select to_char(min(petf_calc.creation_date),'DD-MM-YYYY')
6488: from pay_element_types_f petf_calc,
6489: pay_element_types_f petf
6490: where petf.element_type_id = ele_type_id
6491: and petf_calc.element_name like petf.element_name||'\_New_ Calculator' escape '\';
6492:

Line 6489: pay_element_types_f petf

6485:
6486: cursor upgrade_date (ele_type_id number) is
6487: select to_char(min(petf_calc.creation_date),'DD-MM-YYYY')
6488: from pay_element_types_f petf_calc,
6489: pay_element_types_f petf
6490: where petf.element_type_id = ele_type_id
6491: and petf_calc.element_name like petf.element_name||'\_New_ Calculator' escape '\';
6492:
6493: -- End of changes for 14098797