APPS.PAY_DYN_TRIGGERS dependencies on PAY_PAYROLLS_F

Line 423: from pay_payrolls_f

419: else
420: --
421: select distinct payroll_id
422: into l_payroll_id
423: from pay_payrolls_f
424: where business_group_id = l_bus_grp_id
425: and payroll_name = p_payroll_name;
426: end if;
427: end if;

Line 539: from pay_payrolls_f

535: else
536: --
537: select distinct payroll_id
538: into l_payroll_id
539: from pay_payrolls_f
540: where business_group_id = l_bus_grp_id
541: and payroll_name = p_payroll_name;
542: end if;
543: end if;

Line 776: from pay_payrolls_f

772: where upper(short_name) = upper(p_area_name);
773:
774: cursor csr_sel_payroll_id(p_payroll_name varchar2) is
775: select payroll_id
776: from pay_payrolls_f
777: where upper(payroll_name)= upper(p_payroll_name);
778:
779: cursor csr_sel_bgid(p_business_group_name varchar2) is
780: select business_group_id