APPS.PY_ZA_TX_01032007 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_01032007.LteCalc',1);

Line 567: FROM pay_balance_types pbt

563: hr_utility.set_location('py_za_tx_01032007.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: AND pbt.legislation_code = 'ZA';
570:
571: hr_utility.set_location('py_za_tx_01032007.LteCalc',2);

Line 585: (p_BalNme IN pay_balance_types.balance_name%TYPE

581: RETURN l_BalVal;
582: END getBalVal;
583:
584: FUNCTION getBalVal2
585: (p_BalNme IN pay_balance_types.balance_name%TYPE
586: ,p_EffDte IN DATE
587: ) RETURN NUMBER
588: AS
589: -- Variables

Line 591: l_BalTypId pay_balance_types.balance_type_id%TYPE;

587: ) RETURN NUMBER
588: AS
589: -- Variables
590: l_BalVal BALANCE;
591: l_BalTypId pay_balance_types.balance_type_id%TYPE;
592: l_dimension pay_balance_dimensions.dimension_name%TYPE ;
593: BEGIN
594: hr_utility.set_location('py_za_tx_01032007.LteCalc',3);
595: -- Get the Balance Type ID

Line 598: FROM pay_balance_types pbt

594: hr_utility.set_location('py_za_tx_01032007.LteCalc',3);
595: -- Get the Balance Type ID
596: SELECT pbt.balance_type_id
597: INTO l_BalTypId
598: FROM pay_balance_types pbt
599: WHERE pbt.balance_name = p_BalNme;
600:
601: hr_utility.set_location('py_za_tx_01032007.LteCalc',4);
602: