APPS.PY_ZA_TX_01032005 dependencies on PAY_BALANCE_TYPES

Line 561: (p_BalNme IN pay_balance_types.balance_name%TYPE

557:
558: -- Private Functions
559: --
560: FUNCTION getBalVal
561: (p_BalNme IN pay_balance_types.balance_name%TYPE
562: ,p_EffDte IN DATE
563: ) RETURN NUMBER
564: AS
565: -- Variables

Line 567: l_BalTypId pay_balance_types.balance_type_id%TYPE;

563: ) RETURN NUMBER
564: AS
565: -- Variables
566: l_BalVal BALANCE;
567: l_BalTypId pay_balance_types.balance_type_id%TYPE;
568: l_dimension pay_balance_dimensions.dimension_name%TYPE ;
569:
570: BEGIN
571: hr_utility.set_location('py_za_tx_01032005.LteCalc',1);

Line 575: FROM pay_balance_types pbt

571: hr_utility.set_location('py_za_tx_01032005.LteCalc',1);
572: -- Get the Balance Type ID
573: SELECT pbt.balance_type_id
574: INTO l_BalTypId
575: FROM pay_balance_types pbt
576: WHERE pbt.balance_name = p_BalNme;
577:
578: hr_utility.set_location('py_za_tx_01032005.LteCalc',2);
579:

Line 592: (p_BalNme IN pay_balance_types.balance_name%TYPE

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

Line 598: l_BalTypId pay_balance_types.balance_type_id%TYPE;

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

Line 605: FROM pay_balance_types pbt

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