APPS.PY_ZA_TX_01082000 dependencies on PAY_BALANCE_TYPES

Line 603: (p_BalNme IN pay_balance_types.balance_name%TYPE

599:
600: -- Private Functions
601: --
602: FUNCTION getBalVal
603: (p_BalNme IN pay_balance_types.balance_name%TYPE
604: ,p_EffDte IN DATE
605: ) RETURN NUMBER
606: AS
607: -- Variables

Line 609: l_BalTypId pay_balance_types.balance_type_id%TYPE;

605: ) RETURN NUMBER
606: AS
607: -- Variables
608: l_BalVal NUMBER(15,2);
609: l_BalTypId pay_balance_types.balance_type_id%TYPE;
610: l_dimension pay_balance_dimensions.dimension_name%TYPE ;
611:
612: BEGIN
613: hr_utility.set_location('py_za_tx_01082000.LteCalc',1);

Line 617: FROM pay_balance_types pbt

613: hr_utility.set_location('py_za_tx_01082000.LteCalc',1);
614: -- Get the Balance Type ID
615: SELECT pbt.balance_type_id
616: INTO l_BalTypId
617: FROM pay_balance_types pbt
618: WHERE pbt.balance_name = p_BalNme;
619:
620: hr_utility.set_location('py_za_tx_01082000.LteCalc',2);
621:

Line 640: (p_BalNme IN pay_balance_types.balance_name%TYPE

636: RETURN l_BalVal;
637: END getBalVal;
638:
639: FUNCTION getBalVal2
640: (p_BalNme IN pay_balance_types.balance_name%TYPE
641: ,p_EffDte IN DATE
642: ) RETURN NUMBER
643: AS
644: -- Variables

Line 646: l_BalTypId pay_balance_types.balance_type_id%TYPE;

642: ) RETURN NUMBER
643: AS
644: -- Variables
645: l_BalVal NUMBER(15,2);
646: l_BalTypId pay_balance_types.balance_type_id%TYPE;
647: l_dimension pay_balance_dimensions.dimension_name%TYPE ;
648: BEGIN
649: hr_utility.set_location('py_za_tx_01082000.LteCalc',3);
650: -- Get the Balance Type ID

Line 653: FROM pay_balance_types pbt

649: hr_utility.set_location('py_za_tx_01082000.LteCalc',3);
650: -- Get the Balance Type ID
651: SELECT pbt.balance_type_id
652: INTO l_BalTypId
653: FROM pay_balance_types pbt
654: WHERE pbt.balance_name = p_BalNme;
655:
656: hr_utility.set_location('py_za_tx_01082000.LteCalc',4);
657: