APPS.PAY_AU_TERM_REP dependencies on PAY_BALANCE_TYPES

Line 441: from Pay_Balance_Types

437:
438: Begin
439: /*
440: select Balance_Type_id Into Lv_Balance_Type_id
441: from Pay_Balance_Types
442: Where Balance_Name = 'Lump Sum C Deductions'
443: and Legislation_code = 'AU';
444:
445:

Line 451: from Pay_Balance_Types

447:
448: if p_transitional = 'Y'
449: then
450: select Balance_Type_id Into Lv_Balance_Type_id_1
451: from Pay_Balance_Types
452: Where Balance_Name = 'ETP Deductions Transitional Not Part of Prev Term'
453: and Legislation_code = 'AU';
454:
455: select Balance_Type_id Into Lv_Balance_Type_id_2

Line 456: from Pay_Balance_Types

452: Where Balance_Name = 'ETP Deductions Transitional Not Part of Prev Term'
453: and Legislation_code = 'AU';
454:
455: select Balance_Type_id Into Lv_Balance_Type_id_2
456: from Pay_Balance_Types
457: Where Balance_Name = 'ETP Deductions Transitional Part of Prev Term'
458: and Legislation_code = 'AU';
459: else
460: select Balance_Type_id Into Lv_Balance_Type_id_1

Line 461: from Pay_Balance_Types

457: Where Balance_Name = 'ETP Deductions Transitional Part of Prev Term'
458: and Legislation_code = 'AU';
459: else
460: select Balance_Type_id Into Lv_Balance_Type_id_1
461: from Pay_Balance_Types
462: Where Balance_Name = 'ETP Deductions Life Benefit Not Part of Prev Term'
463: and Legislation_code = 'AU';
464:
465: select Balance_Type_id Into Lv_Balance_Type_id_2

Line 466: from Pay_Balance_Types

462: Where Balance_Name = 'ETP Deductions Life Benefit Not Part of Prev Term'
463: and Legislation_code = 'AU';
464:
465: select Balance_Type_id Into Lv_Balance_Type_id_2
466: from Pay_Balance_Types
467: Where Balance_Name = 'ETP Deductions Life Benefit Part of Prev Term'
468: and Legislation_code = 'AU';
469:
470: end if;

Line 515: from Pay_Balance_Types

511:
512: if p_transitional = 'Y'
513: then
514: select Balance_Type_id Into Lv_Balance_Type_id_1
515: from Pay_Balance_Types
516: Where Balance_Name = 'Invalidity Payments Transitional Not Part of Prev Term'
517: and Legislation_code = 'AU';
518:
519: select Balance_Type_id Into Lv_Balance_Type_id_2

Line 520: from Pay_Balance_Types

516: Where Balance_Name = 'Invalidity Payments Transitional Not Part of Prev Term'
517: and Legislation_code = 'AU';
518:
519: select Balance_Type_id Into Lv_Balance_Type_id_2
520: from Pay_Balance_Types
521: Where Balance_Name = 'Invalidity Payments Transitional Part of Prev Term'
522: and Legislation_code = 'AU';
523: else
524: select Balance_Type_id Into Lv_Balance_Type_id_1

Line 525: from Pay_Balance_Types

521: Where Balance_Name = 'Invalidity Payments Transitional Part of Prev Term'
522: and Legislation_code = 'AU';
523: else
524: select Balance_Type_id Into Lv_Balance_Type_id_1
525: from Pay_Balance_Types
526: Where Balance_Name = 'Invalidity Payments Life Benefit Not Part of Prev Term'
527: and Legislation_code = 'AU';
528:
529: select Balance_Type_id Into Lv_Balance_Type_id_2

Line 530: from Pay_Balance_Types

526: Where Balance_Name = 'Invalidity Payments Life Benefit Not Part of Prev Term'
527: and Legislation_code = 'AU';
528:
529: select Balance_Type_id Into Lv_Balance_Type_id_2
530: from Pay_Balance_Types
531: Where Balance_Name = 'Invalidity Payments Life Benefit Part of Prev Term'
532: and Legislation_code = 'AU';
533:
534: end if;

Line 617: from Pay_Balance_Types

613: and paa.payroll_action_id=ppa.payroll_action_id;
614:
615: begin
616: select Balance_Type_id Into Lv_Balance_Type_id_1
617: from Pay_Balance_Types
618: Where Balance_Name = 'Invalidity Payments Transitional Not Part of Prev Term'
619: and Legislation_code = 'AU';
620:
621: select Balance_Type_id Into Lv_Balance_Type_id_2

Line 622: from Pay_Balance_Types

618: Where Balance_Name = 'Invalidity Payments Transitional Not Part of Prev Term'
619: and Legislation_code = 'AU';
620:
621: select Balance_Type_id Into Lv_Balance_Type_id_2
622: from Pay_Balance_Types
623: Where Balance_Name = 'Invalidity Payments Transitional Part of Prev Term'
624: and Legislation_code = 'AU';
625:
626: