APPS.PY_ZA_TX_01032006 dependencies on PAY_BALANCE_TYPES

Line 546: (p_BalNme IN pay_balance_types.balance_name%TYPE

542:
543: -- Private Functions
544: --
545: FUNCTION getBalVal
546: (p_BalNme IN pay_balance_types.balance_name%TYPE
547: ,p_EffDte IN DATE
548: ) RETURN NUMBER
549: AS
550: -- Variables

Line 552: l_BalTypId pay_balance_types.balance_type_id%TYPE;

548: ) RETURN NUMBER
549: AS
550: -- Variables
551: l_BalVal BALANCE;
552: l_BalTypId pay_balance_types.balance_type_id%TYPE;
553: l_dimension pay_balance_dimensions.dimension_name%TYPE ;
554:
555: BEGIN
556: hr_utility.set_location('py_za_tx_01032006.LteCalc',1);

Line 560: FROM pay_balance_types pbt

556: hr_utility.set_location('py_za_tx_01032006.LteCalc',1);
557: -- Get the Balance Type ID
558: SELECT pbt.balance_type_id
559: INTO l_BalTypId
560: FROM pay_balance_types pbt
561: WHERE pbt.balance_name = p_BalNme
562: AND pbt.legislation_code = 'ZA';
563:
564: hr_utility.set_location('py_za_tx_01032006.LteCalc',2);

Line 578: (p_BalNme IN pay_balance_types.balance_name%TYPE

574: RETURN l_BalVal;
575: END getBalVal;
576:
577: FUNCTION getBalVal2
578: (p_BalNme IN pay_balance_types.balance_name%TYPE
579: ,p_EffDte IN DATE
580: ) RETURN NUMBER
581: AS
582: -- Variables

Line 584: l_BalTypId pay_balance_types.balance_type_id%TYPE;

580: ) RETURN NUMBER
581: AS
582: -- Variables
583: l_BalVal BALANCE;
584: l_BalTypId pay_balance_types.balance_type_id%TYPE;
585: l_dimension pay_balance_dimensions.dimension_name%TYPE ;
586: BEGIN
587: hr_utility.set_location('py_za_tx_01032006.LteCalc',3);
588: -- Get the Balance Type ID

Line 591: FROM pay_balance_types pbt

587: hr_utility.set_location('py_za_tx_01032006.LteCalc',3);
588: -- Get the Balance Type ID
589: SELECT pbt.balance_type_id
590: INTO l_BalTypId
591: FROM pay_balance_types pbt
592: WHERE pbt.balance_name = p_BalNme;
593:
594: hr_utility.set_location('py_za_tx_01032006.LteCalc',4);
595: