DBA Data[Home] [Help]

APPS.PAY_US_SQWL_ERROR dependencies on PAY_PAYROLL_ACTIONS

Line 802: pay_payroll_actions ppa

798: hr_organization_units hou1,
799: per_people_f ppf,
800: per_assignments_f paf,
801: pay_assignment_actions paa,
802: pay_payroll_actions ppa
803: WHERE ppa.payroll_action_id = p_payroll_action_id
804: AND ppa.payroll_action_id = paa.payroll_action_id
805: AND paa.assignment_id = paf.assignment_id
806: /* Added for bug 2506588 */

Line 865: from pay_payroll_actions

861: /* 2nd context of tax_unit_id */
862:
863: cursor c_state (cp_payroll_action_id in number) is
864: select report_qualifier,business_group_id
865: from pay_payroll_actions
866: where payroll_action_id = cp_payroll_action_id;
867:
868: cursor c_get_asg_details(p_asg_action_id in number,
869: p_asg_id in number) is