APPS.PAY_SEED_UTL dependencies on PAY_BALANCE_TYPES

Line 48: from pay_balance_types b, pay_balance_dimensions d, pay_defined_balances db

44: CURSOR c_defined_balance_id(p_balance_name VARCHAR2,
45: p_dimension VARCHAR2,
46: p_legislation_code VARCHAR2) IS
47: select db.defined_balance_id
48: from pay_balance_types b, pay_balance_dimensions d, pay_defined_balances db
49: where b.balance_name = p_balance_name
50: and d.dimension_name = p_dimension
51: and db.balance_type_id = b.balance_type_id
52: and db.balance_dimension_id = d.balance_dimension_id

Line 230: from pay_balance_types

226: -- Cursor to retrieve balance_type_id given name
227: CURSOR c_balance_name_id(p_balance_name VARCHAR2,
228: p_legislation_code VARCHAR2) IS
229: select balance_type_id
230: from pay_balance_types
231: where balance_name = p_balance_name
232: and legislation_code = p_legislation_code
233: and business_group_id IS NULL;
234:

Line 264: from pay_balance_types b, pay_balance_dimensions d, pay_defined_balances db

260: CURSOR c_defined_balance_id(p_balance_name VARCHAR2,
261: p_dimension VARCHAR2,
262: p_legislation_code VARCHAR2) IS
263: select db.defined_balance_id
264: from pay_balance_types b, pay_balance_dimensions d, pay_defined_balances db
265: where b.balance_name = p_balance_name
266: and d.dimension_name = p_dimension
267: and db.balance_type_id = b.balance_type_id
268: and db.balance_dimension_id = d.balance_dimension_id

Line 465: FROM pay_balance_types

461: FUNCTION lookup_balance_name ( p_balance_type_id in number) return varchar2 IS
462: CURSOR csr_balance_name(p_balance_type_id NUMBER) IS
463:
464: SELECT balance_name
465: FROM pay_balance_types
466: WHERE balance_type_id = p_balance_type_id;
467:
468: l_return VARCHAR2(80);
469:

Line 486: FROM pay_balance_types

482: return varchar2 IS
483: CURSOR csr_balance_id(p_balance_name VARCHAR2,
484: p_legislation_code VARCHAR2) IS
485: SELECT balance_type_id
486: FROM pay_balance_types
487: WHERE balance_name = p_balance_name
488: AND legislation_code = p_legislation_code;
489:
490: l_return VARCHAR2(80);

Line 530: FROM pay_balance_types

526: AND legislation_code = p_legislation_code;
527:
528: CURSOR csr_balance_name(p_balance_type_id NUMBER) IS
529: SELECT balance_name
530: FROM pay_balance_types
531: WHERE balance_type_id = p_balance_type_id;
532:
533: CURSOR csr_balance_id(p_balance_name VARCHAR2,
534: p_legislation_code VARCHAR2) IS

Line 536: FROM pay_balance_types

532:
533: CURSOR csr_balance_id(p_balance_name VARCHAR2,
534: p_legislation_code VARCHAR2) IS
535: SELECT balance_name
536: FROM pay_balance_types
537: WHERE balance_name = p_balance_name
538: AND legislation_code = p_legislation_code;
539:
540: l_return VARCHAR2(80);

Line 674: FROM pay_balance_types

670: AND legislation_code = p_legislation_code;
671:
672: CURSOR csr_balance_name(p_balance_type_id NUMBER) IS
673: SELECT balance_name
674: FROM pay_balance_types
675: WHERE balance_type_id = p_balance_type_id;
676:
677: CURSOR csr_balance_id(p_balance_name VARCHAR2,
678: p_legislation_code VARCHAR2) IS

Line 680: FROM pay_balance_types

676:
677: CURSOR csr_balance_id(p_balance_name VARCHAR2,
678: p_legislation_code VARCHAR2) IS
679: SELECT balance_name
680: FROM pay_balance_types
681: WHERE balance_name = p_balance_name
682: AND legislation_code = p_legislation_code;
683:
684: l_return VARCHAR2(80);