APPS.PSP_PEE_BUS dependencies on PER_BUSINESS_GROUPS

Line 30: from per_business_groups_perf pbg

26: --
27: cursor csr_sec_grp is
28: select pbg.security_group_id,
29: pbg.legislation_code
30: from per_business_groups_perf pbg
31: , psp_external_effort_lines pee
32: where pee.external_effort_line_id = p_external_effort_line_id
33: and pbg.business_group_id = pee.business_group_id;
34: --

Line 100: from per_business_groups_perf pbg

96: -- Declare cursor
97: --
98: cursor csr_leg_code is
99: select pbg.legislation_code
100: from per_business_groups_perf pbg
101: , psp_external_effort_lines pee
102: where pee.external_effort_line_id = p_external_effort_line_id
103: and pbg.business_group_id = pee.business_group_id;
104: --

Line 345: FROM per_business_groups

341: l_business_group_id NUMBER;
342: --
343: CURSOR business_group_csr IS
344: SELECT business_group_id
345: FROM per_business_groups
346: where business_group_id = p_business_group_id
347: AND p_distribution_date between DATE_FROM and nvl(DATE_TO,to_date('31/12/4712','DD/MM/RRRR'));
348: --
349: BEGIN

Line 570: per_business_groups pbg

566: --
567: CURSOR currency_csr (p_currency_code IN VARCHAR2, p_distribution_date IN DATE )IS
568: SELECT fc.currency_code
569: FROM fnd_currencies fc,
570: per_business_groups pbg
571: WHERE fc.currency_code =pbg.currency_code
572: AND fc.enabled_flag = 'Y'
573: AND fc.currency_flag = 'Y'
574: AND fc.currency_code = p_currency_code

Line 985: FROM per_business_groups

981: AND ASSIGNMENT_ID = p_assignment_id;
982: */
983: CURSOR business_group_csr(p_business_group_id IN NUMBER, p_distribution_date IN DATE) IS
984: SELECT business_group_id
985: FROM per_business_groups
986: where business_group_id = p_business_group_id
987: AND p_distribution_date between DATE_FROM and nvl(DATE_TO,to_date('31/12/4712','DD/MM/RRRR'));
988:
989: CURSOR set_of_books_csr(p_set_of_books_id IN NUMBER) IS

Line 1016: per_business_groups pbg

1012:
1013: CURSOR currency_csr (p_currency_code IN VARCHAR2, p_distribution_date IN DATE )IS
1014: SELECT fc.currency_code
1015: FROM fnd_currencies fc,
1016: per_business_groups pbg
1017: WHERE fc.currency_code =pbg.currency_code
1018: AND fc.enabled_flag = 'Y'
1019: AND fc.currency_flag = 'Y'
1020: AND fc.currency_code = p_currency_code