APPS.PAY_CA_RULES dependencies on PAY_PAYROLL_ACTIONS

Line 96: ,pay_payroll_actions ppa

92: ,segment12 T4A_RL2_GRE
93: from hr_soft_coding_keyflex hsck
94: ,per_all_assignments_f paf
95: ,pay_assignment_actions paa
96: ,pay_payroll_actions ppa
97: where paa.assignment_action_id = cp_asg_act_id
98: and ppa.payroll_action_id = paa.payroll_action_id
99: and paf.assignment_id = paa.assignment_id
100: and ppa.effective_date between paf.effective_start_date

Line 118: ,pay_payroll_actions ppa

114: ,nvl(segment1, nvl(segment11,segment12) ) tax_unit_id
115: from hr_soft_coding_keyflex hsck
116: ,per_all_assignments_f paf
117: ,pay_assignment_actions paa
118: ,pay_payroll_actions ppa
119: where paa.assignment_action_id = cp_asg_act_id
120: and ppa.payroll_action_id = paa.payroll_action_id
121: and paf.assignment_id = paa.assignment_id
122: and ppa.effective_date between paf.effective_start_date

Line 259: pay_payroll_actions

255: SELECT
256: SYSDATE,
257: NVL(overriding_dd_date,effective_date)
258: FROM
259: pay_payroll_actions
260: WHERE
261: payroll_action_id = p_payroll_action_id;
262:
263: l_direct_deposit_date DATE;

Line 266: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;

262:
263: l_direct_deposit_date DATE;
264: l_dd_date VARCHAR2(30);
265: l_dd_type VARCHAR2(20);
266: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
267: l_text VARCHAR(900);
268: l_override_cpa_code VARCHAR2(100);
269: l_payment_date DATE;
270: l_payment_date1 VARCHAR2(30);

Line 544: pay_payroll_actions

540: legislative_parameters,
541: business_group_id,
542: org_payment_method_id
543: FROM
544: pay_payroll_actions
545: WHERE
546: payroll_action_id = pactid;
547:
548: l_legislative_parameter pay_payroll_actions.legislative_parameters%TYPE;

Line 548: l_legislative_parameter pay_payroll_actions.legislative_parameters%TYPE;

544: pay_payroll_actions
545: WHERE
546: payroll_action_id = pactid;
547:
548: l_legislative_parameter pay_payroll_actions.legislative_parameters%TYPE;
549: l_bg_id pay_payroll_actions.business_group_id%TYPE;
550: l_org_pm_id pay_payroll_actions.org_payment_method_id%TYPE;
551: l_dd_format VARCHAR2(30);
552:

Line 549: l_bg_id pay_payroll_actions.business_group_id%TYPE;

545: WHERE
546: payroll_action_id = pactid;
547:
548: l_legislative_parameter pay_payroll_actions.legislative_parameters%TYPE;
549: l_bg_id pay_payroll_actions.business_group_id%TYPE;
550: l_org_pm_id pay_payroll_actions.org_payment_method_id%TYPE;
551: l_dd_format VARCHAR2(30);
552:
553: BEGIN

Line 550: l_org_pm_id pay_payroll_actions.org_payment_method_id%TYPE;

546: payroll_action_id = pactid;
547:
548: l_legislative_parameter pay_payroll_actions.legislative_parameters%TYPE;
549: l_bg_id pay_payroll_actions.business_group_id%TYPE;
550: l_org_pm_id pay_payroll_actions.org_payment_method_id%TYPE;
551: l_dd_format VARCHAR2(30);
552:
553: BEGIN
554: