APPS.PAY_US_SQWL_ERROR dependencies on PAY_PAYROLL_ACTIONS

Line 16: gv_report_type pay_payroll_actions.report_type%TYPE := 'SQWL'; /* Added for Bug 14456648 */

12: gc_csv_data_delimiter VARCHAR2(1) := '"';
13:
14: gv_package_name VARCHAR2(50) := 'pay_us_sqwl_error';
15:
16: gv_report_type pay_payroll_actions.report_type%TYPE := 'SQWL'; /* Added for Bug 14456648 */
17:
18:
19: /******************************************************************
20: ** Function Returns the formated input string based on the

Line 869: pay_payroll_actions ppa

865: hr_organization_units hou1,
866: per_people_f ppf,
867: per_assignments_f paf,
868: pay_assignment_actions paa,
869: pay_payroll_actions ppa
870: WHERE ppa.payroll_action_id = p_payroll_action_id
871: AND ppa.payroll_action_id = paa.payroll_action_id
872: AND paa.assignment_id = paf.assignment_id
873: /* Added for bug 2506588 */

Line 932: from pay_payroll_actions

928: /* 2nd context of tax_unit_id */
929:
930: cursor c_state (cp_payroll_action_id in number) is
931: select report_qualifier,business_group_id
932: from pay_payroll_actions
933: where payroll_action_id = cp_payroll_action_id;
934:
935: cursor c_get_asg_details(p_asg_action_id in number,
936: p_asg_id in number) is

Line 961: from pay_payroll_actions

957:
958: /* Bug:14456648 */
959: cursor c_get_report_type(c_payroll_action_id number) is
960: select report_type
961: from pay_payroll_actions
962: where payroll_action_id = c_payroll_action_id;
963:
964:
965: TYPE numeric_table IS TABLE OF number(20,2)