DBA Data[Home] [Help]

APPS.BEN_EXTRACT_SEED dependencies on PAY_ALL_PAYROLLS_F

Line 461: cursor cb is SELECT payroll_name from pay_all_payrolls_f

457: = nvl(p_business_group_id,-1)
458: and cm_typ_id = p_val;
459:
460:
461: cursor cb is SELECT payroll_name from pay_all_payrolls_f
462: WHERE nvl(business_group_id,nvl(p_business_group_id,-1))
463: = nvl(p_business_group_id,-1)
464: and trunc(sysdate)
465: between nvl(effective_start_date,trunc(sysdate))

Line 1224: cursor cb is SELECT payroll_id from pay_all_payrolls_f

1220: = nvl(p_business_group_id,-1)
1221: and name = p_meaning ;
1222:
1223:
1224: cursor cb is SELECT payroll_id from pay_all_payrolls_f
1225: WHERE nvl(business_group_id ,nvl(p_business_group_id,-1))
1226: = nvl(p_business_group_id,-1)
1227: and trunc(sysdate)
1228: between nvl(effective_start_date,trunc(sysdate))