APPS.PY_ZA_TX_01032004 dependencies on PAY_BALANCE_TYPES

Line 650: (p_BalNme IN pay_balance_types.balance_name%TYPE

646:
647: -- Private Functions
648: --
649: FUNCTION getBalVal
650: (p_BalNme IN pay_balance_types.balance_name%TYPE
651: ,p_EffDte IN DATE
652: ) RETURN NUMBER
653: AS
654: -- Variables

Line 656: l_BalTypId pay_balance_types.balance_type_id%TYPE;

652: ) RETURN NUMBER
653: AS
654: -- Variables
655: l_BalVal BALANCE;
656: l_BalTypId pay_balance_types.balance_type_id%TYPE;
657: l_dimension pay_balance_dimensions.dimension_name%TYPE ;
658:
659: BEGIN
660: hr_utility.set_location('py_za_tx_01032004.LteCalc',1);

Line 664: FROM pay_balance_types pbt

660: hr_utility.set_location('py_za_tx_01032004.LteCalc',1);
661: -- Get the Balance Type ID
662: SELECT pbt.balance_type_id
663: INTO l_BalTypId
664: FROM pay_balance_types pbt
665: WHERE pbt.balance_name = p_BalNme;
666:
667: hr_utility.set_location('py_za_tx_01032004.LteCalc',2);
668:

Line 688: (p_BalNme IN pay_balance_types.balance_name%TYPE

684: RETURN l_BalVal;
685: END getBalVal;
686:
687: FUNCTION getBalVal2
688: (p_BalNme IN pay_balance_types.balance_name%TYPE
689: ,p_EffDte IN DATE
690: ) RETURN NUMBER
691: AS
692: -- Variables

Line 694: l_BalTypId pay_balance_types.balance_type_id%TYPE;

690: ) RETURN NUMBER
691: AS
692: -- Variables
693: l_BalVal BALANCE;
694: l_BalTypId pay_balance_types.balance_type_id%TYPE;
695: l_dimension pay_balance_dimensions.dimension_name%TYPE ;
696: BEGIN
697: hr_utility.set_location('py_za_tx_01032004.LteCalc',3);
698: -- Get the Balance Type ID

Line 701: FROM pay_balance_types pbt

697: hr_utility.set_location('py_za_tx_01032004.LteCalc',3);
698: -- Get the Balance Type ID
699: SELECT pbt.balance_type_id
700: INTO l_BalTypId
701: FROM pay_balance_types pbt
702: WHERE pbt.balance_name = p_BalNme;
703:
704: hr_utility.set_location('py_za_tx_01032004.LteCalc',4);
705: