APPS.PY_ZA_TX_01032000 dependencies on PAY_BALANCE_TYPES

Line 519: (p_BalNme IN pay_balance_types.balance_name%TYPE

515:
516: -- Private Functions
517: --
518: FUNCTION getBalVal
519: (p_BalNme IN pay_balance_types.balance_name%TYPE
520: ,p_EffDte IN DATE
521: ) RETURN NUMBER
522: AS
523: -- Variables

Line 525: l_BalTypId pay_balance_types.balance_type_id%TYPE;

521: ) RETURN NUMBER
522: AS
523: -- Variables
524: l_BalVal NUMBER(15,2);
525: l_BalTypId pay_balance_types.balance_type_id%TYPE;
526: l_dimension pay_balance_dimensions.dimension_name%TYPE ;
527:
528: BEGIN
529: hr_utility.set_location('py_za_tx_01032000.LteCalc',1);

Line 533: FROM pay_balance_types pbt

529: hr_utility.set_location('py_za_tx_01032000.LteCalc',1);
530: -- Get the Balance Type ID
531: SELECT pbt.balance_type_id
532: INTO l_BalTypId
533: FROM pay_balance_types pbt
534: WHERE pbt.balance_name = p_BalNme;
535:
536: hr_utility.set_location('py_za_tx_01032000.LteCalc',2);
537:

Line 556: (p_BalNme IN pay_balance_types.balance_name%TYPE

552: RETURN l_BalVal;
553: END getBalVal;
554:
555: FUNCTION getBalVal2
556: (p_BalNme IN pay_balance_types.balance_name%TYPE
557: ,p_EffDte IN DATE
558: ) RETURN NUMBER
559: AS
560: -- Variables

Line 562: l_BalTypId pay_balance_types.balance_type_id%TYPE;

558: ) RETURN NUMBER
559: AS
560: -- Variables
561: l_BalVal NUMBER(15,2);
562: l_BalTypId pay_balance_types.balance_type_id%TYPE;
563: l_dimension pay_balance_dimensions.dimension_name%TYPE ;
564: BEGIN
565: hr_utility.set_location('py_za_tx_01032000.LteCalc',3);
566: -- Get the Balance Type ID

Line 569: FROM pay_balance_types pbt

565: hr_utility.set_location('py_za_tx_01032000.LteCalc',3);
566: -- Get the Balance Type ID
567: SELECT pbt.balance_type_id
568: INTO l_BalTypId
569: FROM pay_balance_types pbt
570: WHERE pbt.balance_name = p_BalNme;
571:
572: hr_utility.set_location('py_za_tx_01032000.LteCalc',4);
573: