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.PQP_PTY_BUS dependencies on PER_BUSINESS_GROUPS

Line 1412: from per_business_groups_perf pbg

1408: --
1409: cursor csr_sec_grp is
1410: select pbg.security_group_id,
1411: pbg.legislation_code
1412: from per_business_groups_perf pbg
1413: , pqp_pension_types_f pty
1414: where pty.pension_type_id = p_pension_type_id
1415: and pbg.business_group_id = pty.business_group_id;
1416: --

Line 1482: from per_business_groups_perf pbg

1478: -- Declare cursor
1479: --
1480: cursor csr_leg_code is
1481: select pbg.legislation_code
1482: from per_business_groups_perf pbg
1483: , pqp_pension_types_f pty
1484: where pty.pension_type_id = p_pension_type_id
1485: and pbg.business_group_id (+) = pty.business_group_id;
1486: --

Line 2097: l_legislation_code per_business_groups.legislation_code%TYPE;

2093: FUNCTION get_legislation_code
2094: (p_business_group_id IN NUMBER
2095: ) RETURN VARCHAR2 IS
2096: --declare local variables
2097: l_legislation_code per_business_groups.legislation_code%TYPE;
2098:
2099: CURSOR c_get_leg_code IS
2100: SELECT legislation_code
2101: FROM per_business_groups_perf

Line 2101: FROM per_business_groups_perf

2097: l_legislation_code per_business_groups.legislation_code%TYPE;
2098:
2099: CURSOR c_get_leg_code IS
2100: SELECT legislation_code
2101: FROM per_business_groups_perf
2102: WHERE business_group_id =p_business_group_id;
2103:
2104: BEGIN
2105: OPEN c_get_leg_code;