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.HXT_HXT007A_XMLP_PKG dependencies on PAY_PAYROLLS_X

Line 9: From Pay_Payrolls_X

5: BEGIN
6: DECLARE
7: Cursor Dates_Cur Is
8: Select Effective_Start_Date, Effective_End_Date
9: From Pay_Payrolls_X
10: Where Payroll_Id = P_Payroll_Id;
11:
12: CURSOR payroll_cur(ES_Date In Date, EE_Date In Date)IS
13: SELECT pay.payroll_name

Line 14: FROM pay_payrolls_x pay

10: Where Payroll_Id = P_Payroll_Id;
11:
12: CURSOR payroll_cur(ES_Date In Date, EE_Date In Date)IS
13: SELECT pay.payroll_name
14: FROM pay_payrolls_x pay
15: WHERE pay.business_group_id = (Select Business_Group_Id
16: From Pay_Payrolls_X
17: Where Payroll_Id = P_Payroll_Id
18: And Effective_Start_Date = ES_Date

Line 16: From Pay_Payrolls_X

12: CURSOR payroll_cur(ES_Date In Date, EE_Date In Date)IS
13: SELECT pay.payroll_name
14: FROM pay_payrolls_x pay
15: WHERE pay.business_group_id = (Select Business_Group_Id
16: From Pay_Payrolls_X
17: Where Payroll_Id = P_Payroll_Id
18: And Effective_Start_Date = ES_Date
19: And Effective_End_Date = EE_Date)
20: AND pay.payroll_id = p_payroll_id