APPS.PY_ZA_TX_01032002 dependencies on PAY_BALANCE_TYPES

Line 553: (p_BalNme IN pay_balance_types.balance_name%TYPE

549:
550: -- Private Functions
551: --
552: FUNCTION getBalVal
553: (p_BalNme IN pay_balance_types.balance_name%TYPE
554: ,p_EffDte IN DATE
555: ) RETURN NUMBER
556: AS
557: -- Variables

Line 559: l_BalTypId pay_balance_types.balance_type_id%TYPE;

555: ) RETURN NUMBER
556: AS
557: -- Variables
558: l_BalVal BALANCE;
559: l_BalTypId pay_balance_types.balance_type_id%TYPE;
560: l_dimension pay_balance_dimensions.dimension_name%TYPE ;
561:
562: BEGIN
563: hr_utility.set_location('py_za_tx_01032002.LteCalc',1);

Line 567: FROM pay_balance_types pbt

563: hr_utility.set_location('py_za_tx_01032002.LteCalc',1);
564: -- Get the Balance Type ID
565: SELECT pbt.balance_type_id
566: INTO l_BalTypId
567: FROM pay_balance_types pbt
568: WHERE pbt.balance_name = p_BalNme;
569:
570: hr_utility.set_location('py_za_tx_01032002.LteCalc',2);
571:

Line 591: (p_BalNme IN pay_balance_types.balance_name%TYPE

587: RETURN l_BalVal;
588: END getBalVal;
589:
590: FUNCTION getBalVal2
591: (p_BalNme IN pay_balance_types.balance_name%TYPE
592: ,p_EffDte IN DATE
593: ) RETURN NUMBER
594: AS
595: -- Variables

Line 597: l_BalTypId pay_balance_types.balance_type_id%TYPE;

593: ) RETURN NUMBER
594: AS
595: -- Variables
596: l_BalVal BALANCE;
597: l_BalTypId pay_balance_types.balance_type_id%TYPE;
598: l_dimension pay_balance_dimensions.dimension_name%TYPE ;
599: BEGIN
600: hr_utility.set_location('py_za_tx_01032002.LteCalc',3);
601: -- Get the Balance Type ID

Line 604: FROM pay_balance_types pbt

600: hr_utility.set_location('py_za_tx_01032002.LteCalc',3);
601: -- Get the Balance Type ID
602: SELECT pbt.balance_type_id
603: INTO l_BalTypId
604: FROM pay_balance_types pbt
605: WHERE pbt.balance_name = p_BalNme;
606:
607: hr_utility.set_location('py_za_tx_01032002.LteCalc',4);
608: