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_INV_DED_FORMULAS dependencies on PAY_US_GARN_FEE_RULES_F

Line 595: PAY_US_GARN_FEE_RULES_F target,

591:
592: /* Cursor for Bug 3715182 and 3719168 */
593: CURSOR c_garn_max_fee_amt is
594: select target.MAX_FEE_AMOUNT from
595: PAY_US_GARN_FEE_RULES_F target,
596: PAY_ELEMENT_TYPES_F pet,
597: PAY_ELEMENT_ENTRIES_F pee
598: WHERE target.state_code = substr(P_CTX_JURISDICTION_CODE,1,2)
599: AND target.garn_category = pet.element_information1

Line 1613: PAY_US_GARN_FEE_RULES_F target,

1609:
1610: /* Cursor for Bug 3715182 and 3719168 */
1611: CURSOR c_garn_max_fee_amt is
1612: select target.MAX_FEE_AMOUNT from
1613: PAY_US_GARN_FEE_RULES_F target,
1614: PAY_ELEMENT_TYPES_F pet
1615: WHERE target.state_code = substr(P_CTX_JURISDICTION_CODE,1,2)
1616: AND target.garn_category = pet.element_information1
1617: AND P_CTX_DATE_EARNED BETWEEN target.effective_start_date

Line 3869: PAY_US_GARN_FEE_RULES_F target,

3865:
3866: /* Bug 3722152 */
3867: CURSOR c_garn_max_fee_amt is
3868: select target.MAX_FEE_AMOUNT from
3869: PAY_US_GARN_FEE_RULES_F target,
3870: PAY_ELEMENT_TYPES_F pet
3871: WHERE target.state_code = substr(P_CTX_JURISDICTION_CODE,1,2)
3872: AND target.garn_category = pet.element_information1
3873: AND P_CTX_DATE_EARNED BETWEEN target.effective_start_date