APPS.PY_ZA_TX_01032011 dependencies on PAY_BALANCE_TYPES

Line 869: (p_BalNme IN pay_balance_types.balance_name%TYPE

865:
866: -- Private Functions
867: --
868: FUNCTION getBalVal
869: (p_BalNme IN pay_balance_types.balance_name%TYPE
870: ,p_EffDte IN DATE
871: ) RETURN NUMBER
872: AS
873: -- Variables

Line 875: l_BalTypId pay_balance_types.balance_type_id%TYPE;

871: ) RETURN NUMBER
872: AS
873: -- Variables
874: l_BalVal BALANCE;
875: l_BalTypId pay_balance_types.balance_type_id%TYPE;
876: l_dimension pay_balance_dimensions.dimension_name%TYPE ;
877:
878: BEGIN
879: hr_utility.set_location('py_za_tx_01032011.LteCalc',1);

Line 883: FROM pay_balance_types pbt

879: hr_utility.set_location('py_za_tx_01032011.LteCalc',1);
880: -- Get the Balance Type ID
881: SELECT pbt.balance_type_id
882: INTO l_BalTypId
883: FROM pay_balance_types pbt
884: WHERE pbt.balance_name = p_BalNme
885: AND pbt.legislation_code = 'ZA';
886:
887: hr_utility.set_location('py_za_tx_01032011.LteCalc',2);

Line 901: (p_BalNme IN pay_balance_types.balance_name%TYPE

897: RETURN l_BalVal;
898: END getBalVal;
899:
900: FUNCTION getBalVal2
901: (p_BalNme IN pay_balance_types.balance_name%TYPE
902: ,p_EffDte IN DATE
903: ) RETURN NUMBER
904: AS
905: -- Variables

Line 907: l_BalTypId pay_balance_types.balance_type_id%TYPE;

903: ) RETURN NUMBER
904: AS
905: -- Variables
906: l_BalVal BALANCE;
907: l_BalTypId pay_balance_types.balance_type_id%TYPE;
908: l_dimension pay_balance_dimensions.dimension_name%TYPE ;
909: BEGIN
910: hr_utility.set_location('py_za_tx_01032011.LteCalc',3);
911: -- Get the Balance Type ID

Line 914: FROM pay_balance_types pbt

910: hr_utility.set_location('py_za_tx_01032011.LteCalc',3);
911: -- Get the Balance Type ID
912: SELECT pbt.balance_type_id
913: INTO l_BalTypId
914: FROM pay_balance_types pbt
915: WHERE pbt.balance_name = p_BalNme;
916:
917: hr_utility.set_location('py_za_tx_01032011.LteCalc',4);
918:

Line 6062: from pay_balance_types

6058: pay_payroll_actions BACT,
6059: pay_assignment_actions BAL_ASSACT
6060: where FEED.BALANCE_TYPE_ID = (
6061: select BALANCE_TYPE_ID
6062: from pay_balance_types
6063: where balance_name= 'Tax on Lump Sums'
6064: and legislation_code = 'ZA') -- Balance_type_id for Tax on Lump Sums
6065: and BAL_ASSACT.assignment_action_id = con_ASG_ACT_ID
6066: and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id

Line 6130: from pay_balance_types

6126: pay_payroll_actions BACT,
6127: pay_assignment_actions BAL_ASSACT
6128: where FEED.BALANCE_TYPE_ID = (
6129: select BALANCE_TYPE_ID
6130: from pay_balance_types
6131: where balance_name= 'Tax on Retirement Fund Lump Sums'
6132: and legislation_code = 'ZA') -- Balance_type_id for Tax on Retirement Fund Lump Sums
6133: and BAL_ASSACT.assignment_action_id = con_ASG_ACT_ID
6134: and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id