APPS.PQP_ERG_BUS dependencies on PQP_EXCEPTION_REPORT_GROUPS

Line 29: , pqp_exception_report_groups erg

25: --
26: cursor csr_sec_grp is
27: select pbg.security_group_id
28: from per_business_groups pbg
29: , pqp_exception_report_groups erg
30: , pqp_exception_reports exr
31: where erg.exception_group_id = p_exception_group_id
32: and pbg.business_group_id = exr.business_group_id
33: and exr.exception_report_id = erg.exception_report_id;

Line 91: , pqp_exception_report_groups erg

87: --
88: cursor csr_leg_code is
89: select pbg.legislation_code
90: from per_business_groups pbg
91: , pqp_exception_report_groups erg
92: , pqp_exception_reports exr
93: where erg.exception_group_id = p_exception_group_id
94: and exr.exception_report_id = erg.exception_report_id
95: and pbg.business_group_id = exr.business_group_id;

Line 541: from pqp_exception_report_groups

537: l_dummy char(10);
538: l_leg_code VARCHAR2(20);
539:
540: cursor c1(p_legislation_code VARCHAR2) is select null
541: from pqp_exception_report_groups
542: Where exception_group_id <> nvl(p_exception_group_id,-1)
543: and exception_group_name = p_exception_group_name
544: and (legislation_code is not null and
545: legislation_code = p_legislation_code)

Line 614: l_legislation_code pqp_exception_report_groups.legislation_code%TYPE;

610: ) is
611:
612: l_proc varchar2(72) := g_package||'chk_comp_key_unique';
613: l_dummy char(1);
614: l_legislation_code pqp_exception_report_groups.legislation_code%TYPE;
615:
616: cursor c1 is select null
617: from pqp_exception_report_groups
618: Where exception_group_id <> nvl(p_exception_group_id,-1)

Line 617: from pqp_exception_report_groups

613: l_dummy char(1);
614: l_legislation_code pqp_exception_report_groups.legislation_code%TYPE;
615:
616: cursor c1 is select null
617: from pqp_exception_report_groups
618: Where exception_group_id <> nvl(p_exception_group_id,-1)
619: and exception_group_name = p_exception_group_name
620: and exception_report_id = p_exception_report_id
621: and ((legislation_code is not null