APPS.PY_ZA_TX_UTL_01032000 dependencies on PAY_PAYROLL_ACTIONS

Line 193: , p_TimPrdId pay_payroll_actions.time_period_id%TYPE

189: FUNCTION RetroInPrd RETURN BOOLEAN AS
190: CURSOR c_RetActs(
191: p_AsgId pay_assignment_actions.assignment_id%TYPE
192: , p_AsgActSeq pay_assignment_actions.action_sequence%TYPE
193: , p_TimPrdId pay_payroll_actions.time_period_id%TYPE
194: )
195: IS
196: SELECT 1
197: FROM pay_payroll_actions ppa

Line 197: FROM pay_payroll_actions ppa

193: , p_TimPrdId pay_payroll_actions.time_period_id%TYPE
194: )
195: IS
196: SELECT 1
197: FROM pay_payroll_actions ppa
198: , pay_assignment_actions paa
199: WHERE paa.assignment_id = p_AsgId
200: AND paa.action_sequence < p_AsgActSeq
201: AND paa.payroll_action_id = ppa.payroll_action_id

Line 207: l_TimPrdId pay_payroll_actions.time_period_id%TYPE;

203: AND ppa.action_status = 'C'
204: AND ppa.action_type IN ('O','G');
205:
206: l_AsgActSeq pay_assignment_actions.action_sequence%TYPE;
207: l_TimPrdId pay_payroll_actions.time_period_id%TYPE;
208: v_RetActs c_RetActs%ROWTYPE;
209: -- l_RetroInPeriod BOOLEAN DEFAULT FALSE;
210:
211: BEGIN

Line 219: , pay_payroll_actions ppa

215: , ppa.time_period_id
216: INTO l_AsgActSeq
217: , l_TimPrdId
218: FROM pay_assignment_actions paa
219: , pay_payroll_actions ppa
220: WHERE paa.assignment_action_id = py_za_tx_01032000.con_ASG_ACT_ID
221: AND paa.payroll_action_id = ppa.payroll_action_id;
222:
223: hr_utility.set_location('py_za_tx_utl_01032000.RetroInPrd',2);

Line 1354: l_effective_date pay_payroll_actions.effective_date%TYPE;

1350: --
1351: l_fixed pay_user_column_instances_f.value%TYPE;
1352: l_limit pay_user_column_instances_f.value%TYPE;
1353: l_percentage pay_user_column_instances_f.value%TYPE;
1354: l_effective_date pay_payroll_actions.effective_date%TYPE;
1355: tax_liability NUMBER(15,2);
1356: l_TxbAmt NUMBER(15,2);
1357:
1358: BEGIN

Line 1390: FROM pay_payroll_actions ppa

1386:
1387: /* this selects the effective date for the payroll_run*/
1388: SELECT ppa.effective_date
1389: INTO l_effective_date
1390: FROM pay_payroll_actions ppa
1391: WHERE ppa.payroll_action_id = py_za_tx_01032000.con_PRL_ACT_ID;
1392:
1393: IF py_za_tx_01032000.dbi_TX_STA = 'K' THEN
1394: hr_utility.set_location('py_za_tx_utl_01032000.TaxLiability',10);

Line 2195: from pay_payroll_actions)

2191:
2192: /*DELETE FROM pay_za_tax_traces pztt
2193: WHERE pztt.prl_act_id not in (
2194: SELECT payroll_action_id
2195: from pay_payroll_actions)
2196: */
2197: INSERT INTO pay_za_tax_traces(
2198: ASG_ACT_ID
2199: ,ASG_ID