DBA Data[Home] [Help]

APPS.PAY_PAYROLL_API dependencies on PER_BUSINESS_GROUPS_PERF

Line 557: cursor csr_cost_id_flex_num(c_business_group_id PER_BUSINESS_GROUPS_PERF.business_group_id%TYPE) is

553: l_soft_coding_keyflex_id PAY_ALL_PAYROLLS_F.SOFT_CODING_KEYFLEX_ID%TYPE := p_soft_coding_keyflex_id_in;
554:
555:
556: --Cursor for fetching the Cost allocation structure id from the business group.
557: cursor csr_cost_id_flex_num(c_business_group_id PER_BUSINESS_GROUPS_PERF.business_group_id%TYPE) is
558: select bg.cost_allocation_structure
559: from PER_BUSINESS_GROUPS_PERF bg
560: where bg.business_group_id = c_business_group_id;
561:

Line 559: from PER_BUSINESS_GROUPS_PERF bg

555:
556: --Cursor for fetching the Cost allocation structure id from the business group.
557: cursor csr_cost_id_flex_num(c_business_group_id PER_BUSINESS_GROUPS_PERF.business_group_id%TYPE) is
558: select bg.cost_allocation_structure
559: from PER_BUSINESS_GROUPS_PERF bg
560: where bg.business_group_id = c_business_group_id;
561:
562:
563: --Cursor for fetching the Soft coding structure id from the business group.

Line 1758: cursor csr_cost_id_flex_num(c_business_group_id PER_BUSINESS_GROUPS_PERF.business_group_id%TYPE ) is

1754:
1755: --
1756: --Cursor for getting the Cost allocation structure id from business group id.
1757: --
1758: cursor csr_cost_id_flex_num(c_business_group_id PER_BUSINESS_GROUPS_PERF.business_group_id%TYPE ) is
1759: select bg.cost_allocation_structure
1760: from PER_BUSINESS_GROUPS_PERF bg
1761: where bg.business_group_id = c_business_group_id;
1762:

Line 1760: from PER_BUSINESS_GROUPS_PERF bg

1756: --Cursor for getting the Cost allocation structure id from business group id.
1757: --
1758: cursor csr_cost_id_flex_num(c_business_group_id PER_BUSINESS_GROUPS_PERF.business_group_id%TYPE ) is
1759: select bg.cost_allocation_structure
1760: from PER_BUSINESS_GROUPS_PERF bg
1761: where bg.business_group_id = c_business_group_id;
1762:
1763: --
1764: --Cursor for getting the Soft coding structure id from business group id.