DBA Data[Home] [Help]

APPS.BEN_EXTRACT_SEED dependencies on PAY_ALL_PAYROLLS_F

Line 408: cursor cb is SELECT payroll_name from pay_all_payrolls_f

404: = nvl(p_business_group_id,-1)
405: and cm_typ_id = p_val;
406:
407:
408: cursor cb is SELECT payroll_name from pay_all_payrolls_f
409: WHERE nvl(business_group_id,nvl(p_business_group_id,-1))
410: = nvl(p_business_group_id,-1)
411: and trunc(sysdate)
412: between nvl(effective_start_date,trunc(sysdate))

Line 1171: cursor cb is SELECT payroll_id from pay_all_payrolls_f

1167: = nvl(p_business_group_id,-1)
1168: and name = p_meaning ;
1169:
1170:
1171: cursor cb is SELECT payroll_id from pay_all_payrolls_f
1172: WHERE nvl(business_group_id ,nvl(p_business_group_id,-1))
1173: = nvl(p_business_group_id,-1)
1174: and trunc(sysdate)
1175: between nvl(effective_start_date,trunc(sysdate))