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.CN_PAYGROUP_PVT dependencies on CN_PAYMENT_WORKSHEETS

Line 1041: cn_srp_pay_groups cspg,cn_payment_worksheets cpw,cn_payruns cp

1037: END IF;
1038:
1039: select 1 into l_valid_data from dual where exists
1040: (select count(cp.pay_date) from
1041: cn_srp_pay_groups cspg,cn_payment_worksheets cpw,cn_payruns cp
1042: where
1043: cp.payrun_id = cpw.payrun_id and cp.pay_group_id = cspg.pay_group_id and
1044: cp.org_id = cpw.org_id and cp.org_id = cspg.org_id and
1045: cpw.salesrep_id = cspg.salesrep_id and cpw.org_id = cspg.org_id and

Line 1051: cn_srp_pay_groups cspg,cn_payment_worksheets cpw,cn_payruns cp,cn_period_statuses cps

1047:
1048: if(l_valid_data = 1) then
1049: begin
1050: select max(cps.end_date) into l_pay_period_end_date from
1051: cn_srp_pay_groups cspg,cn_payment_worksheets cpw,cn_payruns cp,cn_period_statuses cps
1052: where
1053: cp.payrun_id = cpw.payrun_id and cp.pay_group_id = cspg.pay_group_id and
1054: cp.org_id = cpw.org_id and cp.org_id = cspg.org_id and
1055: cpw.salesrep_id = cspg.salesrep_id and cpw.org_id = cspg.org_id and