APPS.PY_ZA_TX_UTL_01082000 dependencies on PAY_PAYROLL_ACTIONS

Line 226: , p_TimPrdId pay_payroll_actions.time_period_id%TYPE

222: FUNCTION RetroInPrd RETURN BOOLEAN AS
223: CURSOR c_RetActs(
224: p_AsgId pay_assignment_actions.assignment_id%TYPE
225: , p_AsgActSeq pay_assignment_actions.action_sequence%TYPE
226: , p_TimPrdId pay_payroll_actions.time_period_id%TYPE
227: )
228: IS
229: SELECT 1
230: FROM pay_payroll_actions ppa

Line 230: FROM pay_payroll_actions ppa

226: , p_TimPrdId pay_payroll_actions.time_period_id%TYPE
227: )
228: IS
229: SELECT 1
230: FROM pay_payroll_actions ppa
231: , pay_assignment_actions paa
232: WHERE paa.assignment_id = p_AsgId
233: AND paa.action_sequence < p_AsgActSeq
234: AND paa.payroll_action_id = ppa.payroll_action_id

Line 240: l_TimPrdId pay_payroll_actions.time_period_id%TYPE;

236: AND ppa.action_status = 'C'
237: AND ppa.action_type IN ('O','G');
238:
239: l_AsgActSeq pay_assignment_actions.action_sequence%TYPE;
240: l_TimPrdId pay_payroll_actions.time_period_id%TYPE;
241: v_RetActs c_RetActs%ROWTYPE;
242: -- l_RetroInPeriod BOOLEAN DEFAULT FALSE;
243:
244: BEGIN

Line 252: , pay_payroll_actions ppa

248: , ppa.time_period_id
249: INTO l_AsgActSeq
250: , l_TimPrdId
251: FROM pay_assignment_actions paa
252: , pay_payroll_actions ppa
253: WHERE paa.assignment_action_id = py_za_tx_01082000.con_ASG_ACT_ID
254: AND paa.payroll_action_id = ppa.payroll_action_id;
255:
256: hr_utility.set_location('py_za_tx_utl_01082000.RetroInPrd',2);

Line 2077: l_effective_date pay_payroll_actions.effective_date%TYPE;

2073: --
2074: l_fixed pay_user_column_instances_f.value%TYPE;
2075: l_limit pay_user_column_instances_f.value%TYPE;
2076: l_percentage pay_user_column_instances_f.value%TYPE;
2077: l_effective_date pay_payroll_actions.effective_date%TYPE;
2078: tax_liability NUMBER(15,2);
2079: l_TxbAmt NUMBER(15,2);
2080:
2081: BEGIN

Line 2113: FROM pay_payroll_actions ppa

2109:
2110: /* this selects the effective date for the payroll_run*/
2111: SELECT ppa.effective_date
2112: INTO l_effective_date
2113: FROM pay_payroll_actions ppa
2114: WHERE ppa.payroll_action_id = py_za_tx_01082000.con_PRL_ACT_ID;
2115:
2116: IF py_za_tx_01082000.dbi_TX_STA = 'K' THEN
2117: hr_utility.set_location('py_za_tx_utl_01082000.TaxLiability',10);

Line 2940: from pay_payroll_actions)

2936:
2937: /*DELETE FROM pay_za_tax_traces pztt
2938: WHERE pztt.prl_act_id not in (
2939: SELECT payroll_action_id
2940: from pay_payroll_actions)
2941: */
2942: INSERT INTO pay_za_tax_traces(
2943: ASG_ACT_ID
2944: ,ASG_ID