APPS.PAY_US_TAX_BALS_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 406: from pay_payroll_actions ppa,

402: into l_dummy
403: from dual
404: where exists (
405: select ''
406: from pay_payroll_actions ppa,
407: pay_assignment_actions paa,
408: pay_assignment_latest_balances palb
409: where palb.assignment_id = p_assignment_id
410: and palb.defined_balance_id = l_defined_balance_id

Line 896: from pay_assignment_actions paa,pay_payroll_actions ppa

892:
893: /*
894: CURSOR c_get_min_aaid(p_start_date date , p_end_date date) is
895: select nvl(min(assignment_action_id),-1)
896: from pay_assignment_actions paa,pay_payroll_actions ppa
897: where paa.tax_unit_id = p_gre_id_context
898: and ppa.payroll_action_id = paa.payroll_action_id
899: and ppa.effective_date between p_start_date and p_end_date
900: and ppa.action_type in ('R','Q','I','B','V') ;

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

901: */
902:
903: CURSOR c_get_min_aaid(p_start_date date , p_end_date date,p_bg_id number) is
904: select nvl(min(assignment_action_id),-1)
905: from pay_assignment_actions paa,pay_payroll_actions ppa,pay_payrolls_f ppf
906: where ppa.business_group_id +0 = p_bg_id
907: and ppa.payroll_action_id = paa.payroll_action_id
908: and ppa.effective_date between p_start_date and p_end_date
909: and ppa.action_type in ('R','Q','I','B','V')

Line 1300: pay_payroll_actions pact,

1296: /* Modified query for performance enhancement (Bug 3343974). */
1297: select min(paa.assignment_id)
1298: into l_assignment_id
1299: from pay_assignment_actions paa,
1300: pay_payroll_actions pact,
1301: pay_payrolls_f ppf
1302: where pact.effective_date <= l_virtual_date
1303: and pact.payroll_action_id=paa.payroll_action_id
1304: and pact.action_type in ('R', 'Q', 'I', 'V', 'B')

Line 2071: ' pay_payroll_actions PPA ' ||

2067: g_dim_tbl_asg(0) := 'ASG_GRE_QTD';
2068: g_dim_tbl_jdr(0) := 'N';
2069: g_dim_tbl_crs(0) := 'select distinct PAA.assignment_id ' ||
2070: 'from pay_assignment_actions PAA, ' ||
2071: ' pay_payroll_actions PPA ' ||
2072: 'where PAA.tax_unit_id = :TAX_UNIT_ID ' ||
2073: 'and PPA.payroll_action_id = ' ||
2074: ' PAA.payroll_action_id ' ||
2075: 'and PPA.effective_date >= ' ||

Line 2096: ' pay_payroll_actions PPA ' ||

2092: g_dim_tbl_asg(1) := 'ASG_GRE_YTD';
2093: g_dim_tbl_jdr(1) := 'N';
2094: g_dim_tbl_crs(1) := 'select distinct PAA.assignment_id ' ||
2095: 'from pay_assignment_actions PAA, ' ||
2096: ' pay_payroll_actions PPA ' ||
2097: 'where PAA.tax_unit_id = :TAX_UNIT_ID ' ||
2098: 'and PPA.payroll_action_id = ' ||
2099: ' PAA.payroll_action_id ' ||
2100: 'and PPA.effective_date >= ' ||

Line 2121: ' pay_payroll_actions PPA ' ||

2117: g_dim_tbl_asg(2) := 'SUBJECT_TO_TAX_ASG_GRE_YTD';
2118: g_dim_tbl_jdr(2) := 'N';
2119: g_dim_tbl_crs(2) := 'select distinct PAA.assignment_id ' ||
2120: 'from pay_assignment_actions PAA, ' ||
2121: ' pay_payroll_actions PPA ' ||
2122: 'where PAA.tax_unit_id = :TAX_UNIT_ID ' ||
2123: 'and PPA.payroll_action_id = ' ||
2124: ' PAA.payroll_action_id ' ||
2125: 'and PPA.effective_date >= ' ||

Line 2155: ' from pay_payroll_actions PPA, ' ||

2151: 'PBT.jurisdiction_level) = ' ||
2152: 'substr(:JURISDICTION_CODE, 1, ' ||
2153: 'PBT.jurisdiction_level) ' ||
2154: 'and exists (select 1 ' ||
2155: ' from pay_payroll_actions PPA, ' ||
2156: ' pay_assignment_actions PAA ' ||
2157: ' where PAA.assignment_id = ' ||
2158: 'PAR.assignment_id ' ||
2159: ' and PAA.tax_unit_id = ' ||