APPS.PAY_US_TAX_BALS_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 419: from pay_payroll_actions ppa,

415: into l_dummy
416: from dual
417: where exists (
418: select ''
419: from pay_payroll_actions ppa,
420: pay_assignment_actions paa,
421: pay_assignment_latest_balances palb
422: where palb.assignment_id = p_assignment_id
423: and palb.defined_balance_id = l_defined_balance_id

Line 909: from pay_assignment_actions paa,pay_payroll_actions ppa

905:
906: /*
907: CURSOR c_get_min_aaid(p_start_date date , p_end_date date) is
908: select nvl(min(assignment_action_id),-1)
909: from pay_assignment_actions paa,pay_payroll_actions ppa
910: where paa.tax_unit_id = p_gre_id_context
911: and ppa.payroll_action_id = paa.payroll_action_id
912: and ppa.effective_date between p_start_date and p_end_date
913: and ppa.action_type in ('R','Q','I','B','V') ;

Line 918: from pay_assignment_actions paa,pay_payroll_actions ppa,pay_payrolls_f ppf

914: */
915:
916: CURSOR c_get_min_aaid(p_start_date date , p_end_date date,p_bg_id number) is
917: select nvl(min(assignment_action_id),-1)
918: from pay_assignment_actions paa,pay_payroll_actions ppa,pay_payrolls_f ppf
919: where ppa.business_group_id +0 = p_bg_id
920: and ppa.payroll_action_id = paa.payroll_action_id
921: and ppa.effective_date between p_start_date and p_end_date
922: and ppa.action_type in ('R','Q','I','B','V')

Line 933: FROM pay_assignment_actions paa,pay_payroll_actions ppa

929: where organization_id = p_gre_id_context;
930:
931: CURSOR get_year (p_assign_action_id NUMBER) IS
932: SELECT TO_CHAR(effective_date,'YYYY')
933: FROM pay_assignment_actions paa,pay_payroll_actions ppa
934: WHERE ppa.payroll_action_id = paa.payroll_action_id
935: AND paa.assignment_action_id = p_assign_action_id;
936:
937: --

Line 1391: pay_payroll_actions pact,

1387: /* Modified query for performance enhancement (Bug 3343974). */
1388: select min(paa.assignment_id)
1389: into l_assignment_id
1390: from pay_assignment_actions paa,
1391: pay_payroll_actions pact,
1392: pay_payrolls_f ppf
1393: where pact.effective_date <= l_virtual_date
1394: and pact.payroll_action_id=paa.payroll_action_id
1395: and pact.action_type in ('R', 'Q', 'I', 'V', 'B')

Line 2370: ' pay_payroll_actions PPA ' ||

2366: g_dim_tbl_asg(0) := 'ASG_GRE_QTD';
2367: g_dim_tbl_jdr(0) := 'N';
2368: g_dim_tbl_crs(0) := 'select distinct PAA.assignment_id ' ||
2369: 'from pay_assignment_actions PAA, ' ||
2370: ' pay_payroll_actions PPA ' ||
2371: 'where PAA.tax_unit_id = :TAX_UNIT_ID ' ||
2372: 'and PPA.payroll_action_id = ' ||
2373: ' PAA.payroll_action_id ' ||
2374: 'and PPA.effective_date >= ' ||

Line 2395: ' pay_payroll_actions PPA ' ||

2391: g_dim_tbl_asg(1) := 'ASG_GRE_YTD';
2392: g_dim_tbl_jdr(1) := 'N';
2393: g_dim_tbl_crs(1) := 'select distinct PAA.assignment_id ' ||
2394: 'from pay_assignment_actions PAA, ' ||
2395: ' pay_payroll_actions PPA ' ||
2396: 'where PAA.tax_unit_id = :TAX_UNIT_ID ' ||
2397: 'and PPA.payroll_action_id = ' ||
2398: ' PAA.payroll_action_id ' ||
2399: 'and PPA.effective_date >= ' ||

Line 2420: ' pay_payroll_actions PPA ' ||

2416: g_dim_tbl_asg(2) := 'SUBJECT_TO_TAX_ASG_GRE_YTD';
2417: g_dim_tbl_jdr(2) := 'N';
2418: g_dim_tbl_crs(2) := 'select distinct PAA.assignment_id ' ||
2419: 'from pay_assignment_actions PAA, ' ||
2420: ' pay_payroll_actions PPA ' ||
2421: 'where PAA.tax_unit_id = :TAX_UNIT_ID ' ||
2422: 'and PPA.payroll_action_id = ' ||
2423: ' PAA.payroll_action_id ' ||
2424: 'and PPA.effective_date >= ' ||

Line 2454: ' from pay_payroll_actions PPA, ' ||

2450: 'PBT.jurisdiction_level) = ' ||
2451: 'substr(:JURISDICTION_CODE, 1, ' ||
2452: 'PBT.jurisdiction_level) ' ||
2453: 'and exists (select 1 ' ||
2454: ' from pay_payroll_actions PPA, ' ||
2455: ' pay_assignment_actions PAA ' ||
2456: ' where PAA.assignment_id = ' ||
2457: 'PAR.assignment_id ' ||
2458: ' and PAA.tax_unit_id = ' ||