APPS.PY_ZA_TX_01032012 dependencies on PAY_BALANCE_TYPES

Line 127: FROM pay_balance_types pbt

123: FUNCTION get_def_bal_id (p_bal_name varchar2,
124: p_dim_name varchar2) return number is
125: cursor c_get_def_bal_id is
126: SELECT pdb.defined_balance_id
127: FROM pay_balance_types pbt
128: , pay_balance_dimensions pbd
129: , pay_defined_balances pdb
130: WHERE pbt.balance_name = p_bal_name
131: AND pbd.dimension_name = p_dim_name

Line 1340: (p_BalNme IN pay_balance_types.balance_name%TYPE

1336:
1337: -- Private Functions
1338: --
1339: FUNCTION getBalVal
1340: (p_BalNme IN pay_balance_types.balance_name%TYPE
1341: ,p_EffDte IN DATE
1342: ) RETURN NUMBER
1343: AS
1344: -- Variables

Line 1346: l_BalTypId pay_balance_types.balance_type_id%TYPE;

1342: ) RETURN NUMBER
1343: AS
1344: -- Variables
1345: l_BalVal BALANCE;
1346: l_BalTypId pay_balance_types.balance_type_id%TYPE;
1347: l_dimension pay_balance_dimensions.dimension_name%TYPE ;
1348:
1349: BEGIN
1350: hr_utility.set_location('py_za_tx_01032012.LteCalc',1);

Line 1354: FROM pay_balance_types pbt

1350: hr_utility.set_location('py_za_tx_01032012.LteCalc',1);
1351: -- Get the Balance Type ID
1352: SELECT pbt.balance_type_id
1353: INTO l_BalTypId
1354: FROM pay_balance_types pbt
1355: WHERE pbt.balance_name = p_BalNme
1356: AND pbt.legislation_code = 'ZA';
1357:
1358: hr_utility.set_location('py_za_tx_01032012.LteCalc',2);

Line 1372: (p_BalNme IN pay_balance_types.balance_name%TYPE

1368: RETURN l_BalVal;
1369: END getBalVal;
1370:
1371: FUNCTION getBalVal2
1372: (p_BalNme IN pay_balance_types.balance_name%TYPE
1373: ,p_EffDte IN DATE
1374: ) RETURN NUMBER
1375: AS
1376: -- Variables

Line 1378: l_BalTypId pay_balance_types.balance_type_id%TYPE;

1374: ) RETURN NUMBER
1375: AS
1376: -- Variables
1377: l_BalVal BALANCE;
1378: l_BalTypId pay_balance_types.balance_type_id%TYPE;
1379: l_dimension pay_balance_dimensions.dimension_name%TYPE ;
1380: BEGIN
1381: hr_utility.set_location('py_za_tx_01032012.LteCalc',3);
1382: -- Get the Balance Type ID

Line 1385: FROM pay_balance_types pbt

1381: hr_utility.set_location('py_za_tx_01032012.LteCalc',3);
1382: -- Get the Balance Type ID
1383: SELECT pbt.balance_type_id
1384: INTO l_BalTypId
1385: FROM pay_balance_types pbt
1386: WHERE pbt.balance_name = p_BalNme;
1387:
1388: hr_utility.set_location('py_za_tx_01032012.LteCalc',4);
1389:

Line 7230: , pay_balance_types pbt

7226: , pay_run_result_values target
7227: , pay_balance_feeds_f feed
7228: , pay_run_result_values process
7229: , pay_input_values_f process_iv
7230: , pay_balance_types pbt
7231: , pay_element_types_f pet
7232: , pay_input_values_f piv
7233: WHERE paa.assignment_action_id = p_ass_action_id
7234: AND ppa.payroll_action_id = paa.payroll_action_id

Line 8298: from pay_balance_types

8294: pay_payroll_actions BACT,
8295: pay_assignment_actions BAL_ASSACT
8296: where FEED.BALANCE_TYPE_ID = (
8297: select BALANCE_TYPE_ID
8298: from pay_balance_types
8299: where balance_name= 'Tax on Lump Sums'
8300: and legislation_code = 'ZA') -- Balance_type_id for Tax on Lump Sums
8301: and BAL_ASSACT.assignment_action_id = con_ASG_ACT_ID
8302: and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id

Line 8366: from pay_balance_types

8362: pay_payroll_actions BACT,
8363: pay_assignment_actions BAL_ASSACT
8364: where FEED.BALANCE_TYPE_ID = (
8365: select BALANCE_TYPE_ID
8366: from pay_balance_types
8367: where balance_name= 'Tax on Retirement Fund Lump Sums'
8368: and legislation_code = 'ZA') -- Balance_type_id for Tax on Retirement Fund Lump Sums
8369: and BAL_ASSACT.assignment_action_id = con_ASG_ACT_ID
8370: and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id