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.PA_PAY_INTERFACE dependencies on PA_PAY_EXCLUDE_EXP_TYPES

Line 2291: PA_PAY_EXCLUDE_EXP_TYPES

2287: (
2288: SELECT
2289: EXPENDITURE_TYPE
2290: FROM
2291: PA_PAY_EXCLUDE_EXP_TYPES
2292: WHERE
2293: PAY_ELEMENT_MAP_ID = PPSA.PAY_ELEMENT_MAP_ID
2294: )
2295: GROUP BY

Line 2481: AND expenditure_type NOT IN (SELECT expenditure_type FROM PA_PAY_EXCLUDE_EXP_TYPES

2477:
2478: SELECT DECODE(X.distribution_basis_code,'STHOURS' ,'ST','OTHOURS','OT','ALLHOURS','OT')
2479: FROM dual
2480: )
2481: AND expenditure_type NOT IN (SELECT expenditure_type FROM PA_PAY_EXCLUDE_EXP_TYPES
2482: WHERE pay_element_map_id = X.pay_element_map_id )
2483: GROUP BY NVL(organization_id ,OVERRIDE_TO_ORGANIZATION_ID) ,
2484: project_id ,
2485: task_id

Line 2616: FROM PA_PAY_EXCLUDE_EXP_TYPES

2612: , 'OT')
2613: )
2614: )
2615: AND TEMP.expenditure_type NOT IN (SELECT expenditure_type
2616: FROM PA_PAY_EXCLUDE_EXP_TYPES
2617: WHERE pay_element_map_id = S2.pay_element_map_id
2618: )
2619: GROUP BY Pay_source_id
2620: , NVL(organization_id ,OVERRIDE_TO_ORGANIZATION_ID)

Line 2790: FROM PA_PAY_EXCLUDE_EXP_TYPES

2786: ,'OT')
2787: )
2788: )
2789: AND DIST.expenditure_type NOT IN (SELECT expenditure_type
2790: FROM PA_PAY_EXCLUDE_EXP_TYPES
2791: WHERE pay_element_map_id = S1.pay_element_map_id
2792: )
2793: GROUP BY S1.pay_source_id
2794: , NVL(organization_id ,OVERRIDE_TO_ORGANIZATION_ID)

Line 2833: FROM PA_PAY_EXCLUDE_EXP_TYPES

2829: ,'OT')
2830: )
2831: )
2832: AND TEMP.expenditure_type NOT IN (SELECT expenditure_type
2833: FROM PA_PAY_EXCLUDE_EXP_TYPES
2834: WHERE pay_element_map_id = S2.pay_element_map_id
2835: )
2836: GROUP BY S2.pay_source_id
2837: , NVL(organization_id ,OVERRIDE_TO_ORGANIZATION_ID)

Line 2997: PA_PAY_EXCLUDE_EXP_TYPES

2993: (
2994: SELECT
2995: EXPENDITURE_TYPE
2996: FROM
2997: PA_PAY_EXCLUDE_EXP_TYPES
2998: WHERE
2999: PAY_ELEMENT_MAP_ID = S1.PAY_ELEMENT_MAP_ID
3000: )
3001: GROUP BY

Line 3033: PA_PAY_EXCLUDE_EXP_TYPES

3029: (
3030: SELECT
3031: EXPENDITURE_TYPE
3032: FROM
3033: PA_PAY_EXCLUDE_EXP_TYPES
3034: WHERE
3035: PAY_ELEMENT_MAP_ID = S2.PAY_ELEMENT_MAP_ID
3036: )
3037: GROUP BY