eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_AU_PAYMENT_SUMMARY dependencies on PAY_ASSIGNMENT_ACTIONS

Line 644: v_next_action_id pay_assignment_actions.assignment_action_id%type;

640: p_end_person_id in per_all_people_f.person_id%type,
641: p_chunk in number) is
642:
643:
644: v_next_action_id pay_assignment_actions.assignment_action_id%type;
645:
646: v_lst_year_start date ;
647: v_fbt_year_start date ;
648: v_lst_fbt_year_start date ; --Bug#3661230

Line 719: (select /*+ INDEX(rpac PAY_ASSIGNMENT_ACTIONS_N51)

715: and iipaf.effective_start_date <= v_fin_year_end
716: AND iipaf.payroll_id IS NOT NULL) /*Bug# 4653934*/
717: and a.payroll_id like v_payroll_id -- Bug 3815301
718: and exists
719: (select /*+ INDEX(rpac PAY_ASSIGNMENT_ACTIONS_N51)
720: INDEX(rppa PAY_PAYROLL_ACTIONS_N51*/ ''
721: from
722: pay_payroll_actions rppa
723: ,pay_assignment_actions rpac /*Bug3048962 */

Line 723: ,pay_assignment_actions rpac /Bug3048962 /

719: (select /*+ INDEX(rpac PAY_ASSIGNMENT_ACTIONS_N51)
720: INDEX(rppa PAY_PAYROLL_ACTIONS_N51*/ ''
721: from
722: pay_payroll_actions rppa
723: ,pay_assignment_actions rpac /*Bug3048962 */
724: ,per_assignments_f paaf /*Bug 3815301 */
725: where ( rppa.effective_date between v_fin_year_start and v_fin_year_end
726: or ( pps.actual_termination_date between v_lst_fbt_year_start and v_fbt_year_end /*Bug3263659 */ --Bug#3661230
727: and rppa.effective_date between v_fbt_year_start and v_fbt_year_end

Line 743: pay_assignment_actions paat,

739: )
740: and not exists
741: (select distinct paat.assignment_id
742: from pay_action_interlocks pail,
743: pay_assignment_actions paat,
744: pay_payroll_actions paas
745: where paat.assignment_id = a.assignment_id
746: and paas.action_type ='X'
747: and paas.action_status ='C'

Line 801: (select /*+ INDEX(rpac PAY_ASSIGNMENT_ACTIONS_N51)

797: and iipaf.effective_start_date <= v_fin_year_end
798: AND iipaf.payroll_id IS NOT NULL) /*Bug# 4653934*/
799: and a.payroll_id like v_payroll_id -- Bug 3815301
800: and exists
801: (select /*+ INDEX(rpac PAY_ASSIGNMENT_ACTIONS_N51)
802: INDEX(rppa PAY_PAYROLL_ACTIONS_N51 */ ''
803: from pay_payroll_actions rppa
804: ,pay_assignment_actions rpac/*Bug3048962 */
805: ,per_assignments_f paaf /*Bug 3815301 */

Line 804: ,pay_assignment_actions rpac/Bug3048962 /

800: and exists
801: (select /*+ INDEX(rpac PAY_ASSIGNMENT_ACTIONS_N51)
802: INDEX(rppa PAY_PAYROLL_ACTIONS_N51 */ ''
803: from pay_payroll_actions rppa
804: ,pay_assignment_actions rpac/*Bug3048962 */
805: ,per_assignments_f paaf /*Bug 3815301 */
806: where ( rppa.effective_date between v_fin_year_start and v_fin_year_end
807: or ( pps.actual_termination_date between v_lst_fbt_year_start and v_fbt_year_end /*Bug3263659 */ --Bug#3661230
808: and rppa.effective_date between v_fbt_year_start and v_fbt_year_end

Line 824: pay_assignment_actions paat,

820: )
821: and not exists
822: (select distinct paat.assignment_id
823: from pay_action_interlocks pail,
824: pay_assignment_actions paat,
825: pay_payroll_actions paas
826: where paat.assignment_id = a.assignment_id
827: and paas.action_type ='X'
828: and paas.action_status ='C'

Line 897: (SELECT /*+ INDEX(rpac PAY_ASSIGNMENT_ACTIONS_N51)

893: AND iipaf.effective_start_date <= v_fin_year_end
894: AND iipaf.payroll_id IS NOT NULL) /*Bug# 4653934*/
895: AND a.payroll_id LIKE v_payroll_id -- Bug 3815301
896: AND EXISTS
897: (SELECT /*+ INDEX(rpac PAY_ASSIGNMENT_ACTIONS_N51)
898: INDEX(rppa PAY_PAYROLL_ACTIONS_N51*/ ''
899: FROM
900: pay_payroll_actions rppa
901: ,pay_assignment_actions rpac /*Bug3048962 */

Line 901: ,pay_assignment_actions rpac /Bug3048962 /

897: (SELECT /*+ INDEX(rpac PAY_ASSIGNMENT_ACTIONS_N51)
898: INDEX(rppa PAY_PAYROLL_ACTIONS_N51*/ ''
899: FROM
900: pay_payroll_actions rppa
901: ,pay_assignment_actions rpac /*Bug3048962 */
902: ,per_assignments_f paaf /*Bug 3815301 */
903: WHERE ( rppa.effective_date BETWEEN v_fin_year_start AND v_fin_year_end
904: OR ( pps.actual_termination_date BETWEEN v_lst_fbt_year_start AND v_fbt_year_end /*Bug3263659 */ --Bug#3661230
905: AND rppa.effective_date BETWEEN v_fbt_year_start AND v_fbt_year_end

Line 922: pay_assignment_actions paat,

918: )
919: AND NOT EXISTS
920: (SELECT paat.assignment_id
921: FROM pay_action_interlocks pail,
922: pay_assignment_actions paat,
923: pay_payroll_actions paas
924: WHERE paat.assignment_id = a.assignment_id
925: AND paas.action_type ='X'
926: AND paas.action_status ='C'

Line 947: select pay_assignment_actions_s.nextval

943: );
944:
945:
946: cursor next_action_id is
947: select pay_assignment_actions_s.nextval
948: from dual;
949:
950: /* Bug 5708255 */
951: -------------------------------------------

Line 1182: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,

1178: ------------------------------------------------------------------------+
1179:
1180:
1181: procedure create_extract_archive_details
1182: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
1183: p_user_entity_name in ff_user_entities.user_entity_name%type,
1184: p_value in out nocopy ff_archive_items.value%type) is
1185:
1186:

Line 1321: (p_assignment_action_id in pay_assignment_actions.ASSIGNMENT_ACTION_ID%TYPE

1317: -- Passed Balance name Bug #2454595
1318: ----------------------------------------------------------------------+
1319:
1320: procedure archive_balance_details
1321: (p_assignment_action_id in pay_assignment_actions.ASSIGNMENT_ACTION_ID%TYPE
1322: ,p_max_assignment_action_id in pay_assignment_actions.ASSIGNMENT_ACTION_ID%TYPE --2610141
1323: ,p_registered_employer in NUMBER
1324: ,p_database_item_name in ff_database_items.user_name%TYPE
1325: ,p_balance_name in pay_balance_types.balance_name%TYPE

Line 1322: ,p_max_assignment_action_id in pay_assignment_actions.ASSIGNMENT_ACTION_ID%TYPE --2610141

1318: ----------------------------------------------------------------------+
1319:
1320: procedure archive_balance_details
1321: (p_assignment_action_id in pay_assignment_actions.ASSIGNMENT_ACTION_ID%TYPE
1322: ,p_max_assignment_action_id in pay_assignment_actions.ASSIGNMENT_ACTION_ID%TYPE --2610141
1323: ,p_registered_employer in NUMBER
1324: ,p_database_item_name in ff_database_items.user_name%TYPE
1325: ,p_balance_name in pay_balance_types.balance_name%TYPE
1326: ,p_legislation_code in pay_defined_balances.legislation_code%TYPE

Line 1329: ,p_assignment_id in pay_assignment_actions.ASSIGNMENT_ID%type

1325: ,p_balance_name in pay_balance_types.balance_name%TYPE
1326: ,p_legislation_code in pay_defined_balances.legislation_code%TYPE
1327: ,p_year_start in DATE
1328: ,p_year_end in DATE
1329: ,p_assignment_id in pay_assignment_actions.ASSIGNMENT_ID%type
1330: ,p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE
1331: ,p_bal_value OUT NOCOPY varchar2) IS -- Bug 3098353
1332:
1333: v_bal_value varchar2(20);

Line 1356: c_assignment_id pay_assignment_actions.assignment_id%type)

1352: -- Bug #2454595
1353: -------------------------------------------------------------------+
1354: cursor c_archive_fbt_info(c_balance_name pay_balance_types.balance_name%type,
1355: c_year_end DATE,
1356: c_assignment_id pay_assignment_actions.assignment_id%type)
1357: is
1358: select pay_balance_pkg.get_value(pdb.defined_balance_id,
1359: p_max_assignment_action_id,
1360: p_registered_employer,

Line 1391: c_assignment_id pay_assignment_actions.assignment_id%type,

1387: AND effective_end_date ;
1388:
1389: /* Bug: 3095919 Cursor to fetch Lump sum E payments PTD value */
1390: CURSOR c_single_lumpsum_E_payment(c_effective_date DATE,
1391: c_assignment_id pay_assignment_actions.assignment_id%type,
1392: c_assignment_action_id pay_assignment_actions.assignment_action_id%type) --2610141
1393: IS
1394: select sum(pay_balance_pkg.get_value(pdb.defined_balance_id,
1395: c_assignment_action_id,

Line 1392: c_assignment_action_id pay_assignment_actions.assignment_action_id%type) --2610141

1388:
1389: /* Bug: 3095919 Cursor to fetch Lump sum E payments PTD value */
1390: CURSOR c_single_lumpsum_E_payment(c_effective_date DATE,
1391: c_assignment_id pay_assignment_actions.assignment_id%type,
1392: c_assignment_action_id pay_assignment_actions.assignment_action_id%type) --2610141
1393: IS
1394: select sum(pay_balance_pkg.get_value(pdb.defined_balance_id,
1395: c_assignment_action_id,
1396: p_registered_employer,

Line 1411: CURSOR c_get_pay_effective_date(c_assignment_id pay_assignment_actions.assignment_id%type

1407: /* Bug No: 3603495 - Performance Fix in c_get_pay_effective_date - Introduced per_assignments_f and its joins */
1408: /* Bug 4363057 - Cursor has been modified so that the Lump Sum E Payments given to previous legal employers
1409: can be taken into account while calculating payment summary gross.*/
1410:
1411: CURSOR c_get_pay_effective_date(c_assignment_id pay_assignment_actions.assignment_id%type
1412: ,c_year_start in DATE
1413: ,c_year_end in DATE)
1414: IS
1415: select /*+ USE_NL(ptp) */ -- Bug 4925650

Line 1419: pay_assignment_Actions paa,

1415: select /*+ USE_NL(ptp) */ -- Bug 4925650
1416: max(paa.assignment_action_id) -- Bug: 3095919, Bug 2610141
1417: from per_assignments_f paf,
1418: pay_payroll_Actions ppa,
1419: pay_assignment_Actions paa,
1420: per_time_periods ptp
1421: where ppa.payroll_Action_id = paa.payroll_Action_id
1422: and paa.assignment_id = c_assignment_id
1423: and paf.assignment_id = paa.assignment_id

Line 1731: ,p_assignment_id in pay_assignment_actions.ASSIGNMENT_ID%type

1727:
1728: function adjust_retro_allowances(t_allowance_balance IN OUT NOCOPY tab_allownace_balance
1729: ,p_year_start in DATE
1730: ,p_year_end in DATE
1731: ,p_assignment_id in pay_assignment_actions.ASSIGNMENT_ID%type
1732: ,p_registered_employer in NUMBER --2610141
1733: )
1734: return number
1735: is

Line 1739: c_assignment_id pay_assignment_actions.assignment_id%type)

1735: is
1736:
1737: CURSOR Get_retro_Entry_ids(c_year_start DATE,
1738: c_year_end DATE,
1739: c_assignment_id pay_assignment_actions.assignment_id%type)
1740: IS
1741: SELECT /*+ ORDERED */ pee.element_entry_id element_entry_id,
1742: ppa.date_earned date_earned,
1743: pee.assignment_id assignment_id,

Line 1747: ,pay_assignment_actions pac

1743: pee.assignment_id assignment_id,
1744: pac.tax_unit_id /* Added for bug #5846278 */
1745: FROM per_all_assignments_f paa
1746: ,per_periods_of_service pps
1747: ,pay_assignment_actions pac
1748: ,pay_payroll_actions ppa
1749: ,pay_element_entries_f pee
1750: ,pay_run_results prr
1751: ,pay_element_types_f pet

Line 2043: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type

2039: --* Archive Allowance details
2040: -----------------------------
2041:
2042: procedure archive_allowance_details
2043: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type
2044: ,p_max_assignment_action_id in pay_assignment_actions.assignment_action_id%type
2045: ,p_registered_employer in number
2046: ,p_year_start in date
2047: ,p_year_end in date

Line 2044: ,p_max_assignment_action_id in pay_assignment_actions.assignment_action_id%type

2040: -----------------------------
2041:
2042: procedure archive_allowance_details
2043: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type
2044: ,p_max_assignment_action_id in pay_assignment_actions.assignment_action_id%type
2045: ,p_registered_employer in number
2046: ,p_year_start in date
2047: ,p_year_end in date
2048: ,p_assignment_id in pay_assignment_actions.assignment_id%type

Line 2048: ,p_assignment_id in pay_assignment_actions.assignment_id%type

2044: ,p_max_assignment_action_id in pay_assignment_actions.assignment_action_id%type
2045: ,p_registered_employer in number
2046: ,p_year_start in date
2047: ,p_year_end in date
2048: ,p_assignment_id in pay_assignment_actions.assignment_id%type
2049: ,p_alw_bal_exist out nocopy varchar2 -- 3098353
2050: ) IS
2051: l_procedure constant varchar2(80) := g_package||'.archive_allowance_details';
2052: /*

Line 2060: ,c_assignment_id pay_assignment_actions.assignment_id%type

2056: */
2057: cursor get_allowance_balances
2058: (c_year_start date
2059: ,c_year_end date
2060: ,c_assignment_id pay_assignment_actions.assignment_id%type
2061: ,c_dimension_id pay_balance_dimensions.balance_dimension_id%type
2062: ) IS
2063: select balance_name
2064: , pay_balance_pkg.get_value(def_id,p_max_assignment_action_id,p_registered_employer,null,null,null,null) balance_value

Line 2078: , pay_assignment_actions pac

2074: , pay_defined_balances pdb
2075: --, pay_balance_dimensions pbd
2076: --, per_periods_of_service pps
2077: , pay_payroll_actions ppa
2078: , pay_assignment_actions pac
2079: , pay_run_results prr
2080: where pac.assignment_id = c_assignment_id
2081: and pac.tax_unit_id = p_registered_employer --2610141
2082: and paa.assignment_id = pac.assignment_id

Line 2247: ( p_assignment_action_id pay_assignment_actions.assignment_action_id%type,

2243: -- X_ETP_EMPLOYEE_PAYMENT_DATE
2244: -----------------------------------------------------------
2245:
2246: procedure archive_etp_payment_details
2247: ( p_assignment_action_id pay_assignment_actions.assignment_action_id%type,
2248: p_registered_employer NUMBER, --2610141
2249: p_assignment_id per_all_Assignments_f.assignment_id%type ,
2250: p_year_start date,
2251: p_year_end date ) as

Line 2267: ,pay_assignment_actions pac

2263: ,pay_input_values_f piv
2264: ,per_all_assignments_f paa
2265: ,pay_run_results prr
2266: ,pay_run_result_values prv
2267: ,pay_assignment_actions pac
2268: ,pay_payroll_actions ppa
2269: ,pay_payrolls_f papf /* bug Number 4278361 */
2270: where pet.element_type_id = piv.element_type_id
2271: and pet.element_name = 'ETP on Termination'

Line 2295: (c_assignment_action_id pay_assignment_actions.assignment_action_id%type,

2291: and c_year_end
2292: and pac.tax_unit_id = p_registered_employer; --2610141
2293:
2294: cursor etp_prepayment
2295: (c_assignment_action_id pay_assignment_actions.assignment_action_id%type,
2296: c_payroll_action_id pay_payroll_actions.payroll_action_id%type,
2297: c_year_start date,
2298: c_year_end date )
2299: is select to_char(pppa.effective_date,'DDMMYYYY')

Line 2301: ,pay_assignment_actions pac

2297: c_year_start date,
2298: c_year_end date )
2299: is select to_char(pppa.effective_date,'DDMMYYYY')
2300: from pay_action_interlocks pai
2301: ,pay_assignment_actions pac
2302: ,pay_payroll_actions ppa
2303: ,pay_assignment_actions ppac
2304: ,pay_payroll_actions pppa
2305: where pac.payroll_action_id = ppa.payroll_action_id

Line 2303: ,pay_assignment_actions ppac

2299: is select to_char(pppa.effective_date,'DDMMYYYY')
2300: from pay_action_interlocks pai
2301: ,pay_assignment_actions pac
2302: ,pay_payroll_actions ppa
2303: ,pay_assignment_actions ppac
2304: ,pay_payroll_actions pppa
2305: where pac.payroll_action_id = ppa.payroll_action_id
2306: and pac.assignment_action_id = c_assignment_action_id
2307: and pac.assignment_action_id = pai.locked_action_id

Line 2327: ,pay_assignment_actions pac

2323: c_year_end date )
2324: is select max(ppa.payroll_action_id) payroll_action_id
2325: ,max(pac.assignment_action_id) assignment_action_id
2326: from per_assignments_f paf
2327: ,pay_assignment_actions pac
2328: ,pay_payroll_actions ppa
2329: where pac.assignment_id = c_assignment_id
2330: and pac.tax_unit_id = p_registered_employer --2610141
2331: and paf.assignment_id = pac.assignment_id

Line 2420: ,p_assignment_action_id in pay_assignment_actions.assignment_action_id%type

2416: --------------------------------------------------------------------
2417: --
2418: procedure archive_2006_unions
2419: (p_assignment_id in per_all_assignments.assignment_id%type
2420: ,p_assignment_action_id in pay_assignment_actions.assignment_action_id%type
2421: ,p_max_assignment_action_id in pay_assignment_actions.assignment_action_id%type
2422: ,p_registered_employer in number
2423: ,p_year_start in date
2424: ,p_year_end in date

Line 2421: ,p_max_assignment_action_id in pay_assignment_actions.assignment_action_id%type

2417: --
2418: procedure archive_2006_unions
2419: (p_assignment_id in per_all_assignments.assignment_id%type
2420: ,p_assignment_action_id in pay_assignment_actions.assignment_action_id%type
2421: ,p_max_assignment_action_id in pay_assignment_actions.assignment_action_id%type
2422: ,p_registered_employer in number
2423: ,p_year_start in date
2424: ,p_year_end in date
2425: --,p_alw_bal_exist out nocopy varchar2

Line 2444: , pay_assignment_actions pac

2440: , per_all_assignments_f paa
2441: , pay_balance_types pbt
2442: , pay_defined_balances pdb
2443: , pay_payroll_actions ppa
2444: , pay_assignment_actions pac
2445: , pay_run_results prr
2446: , pay_balance_feeds_f pbf
2447: , pay_input_values_f piv
2448: where pac.assignment_id = p_assignment_id

Line 2649: ,p_assignment_action_id in pay_assignment_actions.assignment_action_id%type

2645: ----------------------------------------------------------------------+
2646: --
2647: procedure archive_union_name
2648: (p_assignment_id in per_all_assignments.assignment_id%type
2649: ,p_assignment_action_id in pay_assignment_actions.assignment_action_id%type
2650: ,p_max_assignment_action_id in pay_assignment_actions.assignment_action_id%type
2651: ,p_registered_employer number
2652: ,p_year_start in date
2653: ,p_year_end in date

Line 2650: ,p_max_assignment_action_id in pay_assignment_actions.assignment_action_id%type

2646: --
2647: procedure archive_union_name
2648: (p_assignment_id in per_all_assignments.assignment_id%type
2649: ,p_assignment_action_id in pay_assignment_actions.assignment_action_id%type
2650: ,p_max_assignment_action_id in pay_assignment_actions.assignment_action_id%type
2651: ,p_registered_employer number
2652: ,p_year_start in date
2653: ,p_year_end in date
2654: ) as

Line 2830: p_assignment_Action_id in pay_assignment_actions.assignment_action_id%type,

2826: Procedure archive_etp_details
2827: (p_business_group_id in hr_organization_units.business_group_id%type,
2828: p_registered_employer in hr_organization_units.organization_id%type,
2829: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
2830: p_assignment_Action_id in pay_assignment_actions.assignment_action_id%type,
2831: p_assignment_id in pay_assignment_actions.assignment_id%type,
2832: p_year_start in pay_payroll_actions.effective_date%type,
2833: p_year_end in pay_payroll_Actions.effective_date%type,
2834: p_lst_year_start in pay_payroll_Actions.effective_date%type,/*Bug3661230 Added one extra parameter*/

Line 2831: p_assignment_id in pay_assignment_actions.assignment_id%type,

2827: (p_business_group_id in hr_organization_units.business_group_id%type,
2828: p_registered_employer in hr_organization_units.organization_id%type,
2829: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
2830: p_assignment_Action_id in pay_assignment_actions.assignment_action_id%type,
2831: p_assignment_id in pay_assignment_actions.assignment_id%type,
2832: p_year_start in pay_payroll_actions.effective_date%type,
2833: p_year_end in pay_payroll_Actions.effective_date%type,
2834: p_lst_year_start in pay_payroll_Actions.effective_date%type,/*Bug3661230 Added one extra parameter*/
2835: p_transitional_flag out nocopy varchar2, /*Bug 6192381 Added New Parameters p_transitional_flag and p_part_prev_etp_flag */

Line 2865: c_assignment_id in pay_assignment_actions.assignment_id%type,

2861: -----------------------------------------------------------------------------------------------+
2862: cursor etp_details( c_business_group_id in hr_organization_units.business_group_id%type,
2863: c_registered_employer in hr_organization_units.organization_id%type,
2864: c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
2865: c_assignment_id in pay_assignment_actions.assignment_id%type,
2866: c_year_start in pay_payroll_actions.effective_date%type,
2867: c_year_end in pay_payroll_Actions.effective_date%type)
2868: is
2869: select pev.screen_entry_value tax_file_number

Line 2903: pay_assignment_actions pac,

2899: per_addresses pad,
2900: fnd_territories_tl fta,
2901: per_periods_of_service pps,
2902: pay_payroll_actions ppa,
2903: pay_assignment_actions pac,
2904: hr_locations_all hlc /* Bug No : 2263587 */
2905: where hou.business_group_id = c_business_group_id
2906: and hou.organization_id = c_registered_employer
2907: and ppa.action_type = 'X'

Line 2962: ,pay_assignment_actions pac

2958: ,pay_input_values_f piv
2959: ,per_all_assignments_f paa
2960: ,pay_run_results prr
2961: ,pay_run_result_values prv
2962: ,pay_assignment_actions pac
2963: ,pay_payroll_actions ppa
2964: where pet.element_type_id = piv.element_type_id
2965: and pet.element_name = 'ETP on Termination'
2966: and piv.name in ('Transitional ETP','Part of Previously Paid ETP')

Line 3150: (p_assignment_action_id in pay_assignment_actions.ASSIGNMENT_ACTION_ID%TYPE

3146: ---------------------------------------------------------------------+
3147:
3148:
3149: procedure archive_prepost_details
3150: (p_assignment_action_id in pay_assignment_actions.ASSIGNMENT_ACTION_ID%TYPE
3151: ,p_max_assignment_action_id in pay_assignment_actions.ASSIGNMENT_ACTION_ID%TYPE --2610141
3152: ,p_registered_employer in pay_assignment_actions.TAX_UNIT_ID%TYPE --2610141
3153: ,p_legislation_code in pay_defined_balances.legislation_code%TYPE
3154: ,p_assignment_id in pay_assignment_actions.ASSIGNMENT_ID%type

Line 3151: ,p_max_assignment_action_id in pay_assignment_actions.ASSIGNMENT_ACTION_ID%TYPE --2610141

3147:
3148:
3149: procedure archive_prepost_details
3150: (p_assignment_action_id in pay_assignment_actions.ASSIGNMENT_ACTION_ID%TYPE
3151: ,p_max_assignment_action_id in pay_assignment_actions.ASSIGNMENT_ACTION_ID%TYPE --2610141
3152: ,p_registered_employer in pay_assignment_actions.TAX_UNIT_ID%TYPE --2610141
3153: ,p_legislation_code in pay_defined_balances.legislation_code%TYPE
3154: ,p_assignment_id in pay_assignment_actions.ASSIGNMENT_ID%type
3155: ,p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE

Line 3152: ,p_registered_employer in pay_assignment_actions.TAX_UNIT_ID%TYPE --2610141

3148:
3149: procedure archive_prepost_details
3150: (p_assignment_action_id in pay_assignment_actions.ASSIGNMENT_ACTION_ID%TYPE
3151: ,p_max_assignment_action_id in pay_assignment_actions.ASSIGNMENT_ACTION_ID%TYPE --2610141
3152: ,p_registered_employer in pay_assignment_actions.TAX_UNIT_ID%TYPE --2610141
3153: ,p_legislation_code in pay_defined_balances.legislation_code%TYPE
3154: ,p_assignment_id in pay_assignment_actions.ASSIGNMENT_ID%type
3155: ,p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE
3156: ,p_actual_termination_date in per_periods_of_service.actual_termination_date%TYPE

Line 3154: ,p_assignment_id in pay_assignment_actions.ASSIGNMENT_ID%type

3150: (p_assignment_action_id in pay_assignment_actions.ASSIGNMENT_ACTION_ID%TYPE
3151: ,p_max_assignment_action_id in pay_assignment_actions.ASSIGNMENT_ACTION_ID%TYPE --2610141
3152: ,p_registered_employer in pay_assignment_actions.TAX_UNIT_ID%TYPE --2610141
3153: ,p_legislation_code in pay_defined_balances.legislation_code%TYPE
3154: ,p_assignment_id in pay_assignment_actions.ASSIGNMENT_ID%type
3155: ,p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE
3156: ,p_actual_termination_date in per_periods_of_service.actual_termination_date%TYPE
3157: ,p_date_start in per_periods_of_service.date_start%TYPE
3158: ,p_year_start in pay_payroll_actions.effective_date%type

Line 3513: p_max_assignment_action_id in pay_assignment_actions.assignment_action_id%TYPE, --2610141

3509: ---------------------------------------------------------------------------------------+
3510:
3511: Procedure archive_employer_details
3512: (p_business_group_id in hr_organization_units.business_group_id%type,
3513: p_max_assignment_action_id in pay_assignment_actions.assignment_action_id%TYPE, --2610141
3514: p_registered_employer in hr_organization_units.organization_id%type,
3515: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
3516: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
3517: p_assignment_id in pay_assignment_actions.assignment_id%type,

Line 3516: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,

3512: (p_business_group_id in hr_organization_units.business_group_id%type,
3513: p_max_assignment_action_id in pay_assignment_actions.assignment_action_id%TYPE, --2610141
3514: p_registered_employer in hr_organization_units.organization_id%type,
3515: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
3516: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
3517: p_assignment_id in pay_assignment_actions.assignment_id%type,
3518: p_year_start in pay_payroll_actions.effective_date%type,
3519: p_year_end in pay_payroll_Actions.effective_date%type) is
3520:

Line 3517: p_assignment_id in pay_assignment_actions.assignment_id%type,

3513: p_max_assignment_action_id in pay_assignment_actions.assignment_action_id%TYPE, --2610141
3514: p_registered_employer in hr_organization_units.organization_id%type,
3515: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
3516: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
3517: p_assignment_id in pay_assignment_actions.assignment_id%type,
3518: p_year_start in pay_payroll_actions.effective_date%type,
3519: p_year_end in pay_payroll_Actions.effective_date%type) is
3520:
3521:

Line 3740: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,

3736: Procedure archive_employee_details
3737: (p_business_group_id in hr_organization_units.business_group_id%type,
3738: p_registered_employer in hr_organization_units.organization_id%type,
3739: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
3740: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
3741: p_assignment_id in pay_assignment_actions.assignment_id%type,
3742: p_year_start in pay_payroll_actions.effective_date%type,
3743: p_year_end in pay_payroll_Actions.effective_date%type,
3744: p_end_date_flag in varchar2,

Line 3741: p_assignment_id in pay_assignment_actions.assignment_id%type,

3737: (p_business_group_id in hr_organization_units.business_group_id%type,
3738: p_registered_employer in hr_organization_units.organization_id%type,
3739: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
3740: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
3741: p_assignment_id in pay_assignment_actions.assignment_id%type,
3742: p_year_start in pay_payroll_actions.effective_date%type,
3743: p_year_end in pay_payroll_Actions.effective_date%type,
3744: p_end_date_flag in varchar2,
3745: p_fbt_year_start IN pay_payroll_Actions.effective_date%type) is /*Bug# 4653934*/

Line 3875: pay_assignment_actions pac,

3871: per_addresses pad,
3872: fnd_territories_tl fta,
3873: per_periods_of_service pps,
3874: pay_payroll_actions ppa,
3875: pay_assignment_actions pac,
3876: pay_payroll_actions ppa1, /* Bug# 2448441 */
3877: pay_assignment_actions pac1 /* Bug# 2448441 */
3878: where hou.business_group_id = p_business_group_id
3879: and hou.organization_id = p_registered_employer

Line 3877: pay_assignment_actions pac1 /* Bug# 2448441 */

3873: per_periods_of_service pps,
3874: pay_payroll_actions ppa,
3875: pay_assignment_actions pac,
3876: pay_payroll_actions ppa1, /* Bug# 2448441 */
3877: pay_assignment_actions pac1 /* Bug# 2448441 */
3878: where hou.business_group_id = p_business_group_id
3879: and hou.organization_id = p_registered_employer
3880: and ppa.action_type = 'X'
3881: and hou.organization_id = hoi.organization_id

Line 3904: pay_assignment_actions paa2

3900: and paa.assignment_id = pac1.assignment_id
3901: and ppa1.payroll_action_id = pac1.payroll_action_id
3902: and pac1.assignment_action_id = (select to_number(substr(max(lpad(paa2.action_sequence,15,'0')||paa2.assignment_action_id),16)) /*Bug 7242551 */
3903: from pay_payroll_actions ppa2,
3904: pay_assignment_actions paa2
3905: where ppa2.action_type in ('R','Q','B','I') --Bug 2574186
3906: and ppa2.payroll_action_id = paa2.payroll_action_id
3907: and paa2.tax_unit_id = p_registered_employer -- Bug 2610141
3908: and paa2.assignment_id = paa.assignment_id

Line 4263: p_assignment_Action_id in pay_assignment_actions.assignment_action_id%type,

4259: Procedure archive_supplier_details
4260: (p_business_group_id in hr_organization_units.business_group_id%type,
4261: p_registered_employer in hr_organization_units.organization_id%type,
4262: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
4263: p_assignment_Action_id in pay_assignment_actions.assignment_action_id%type,
4264: p_assignment_id in pay_assignment_actions.assignment_id%type,
4265: p_year_start in pay_payroll_actions.effective_date%type,
4266: p_year_end in pay_payroll_Actions.effective_date%type) is
4267:

Line 4264: p_assignment_id in pay_assignment_actions.assignment_id%type,

4260: (p_business_group_id in hr_organization_units.business_group_id%type,
4261: p_registered_employer in hr_organization_units.organization_id%type,
4262: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
4263: p_assignment_Action_id in pay_assignment_actions.assignment_action_id%type,
4264: p_assignment_id in pay_assignment_actions.assignment_id%type,
4265: p_year_start in pay_payroll_actions.effective_date%type,
4266: p_year_end in pay_payroll_Actions.effective_date%type) is
4267:
4268:

Line 4559: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type

4555: -- 5. archive_supplier_details
4556: -- 6. archive_employee_details
4557: --------------------------------------------------------------------+
4558: procedure archive_code
4559: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type
4560: ,p_effective_date in date
4561: ) is
4562: --
4563: l_procedure constant varchar2(80) := g_package || '.archive_code';

Line 4564: l_assignment_id pay_assignment_actions.assignment_id%type;

4560: ,p_effective_date in date
4561: ) is
4562: --
4563: l_procedure constant varchar2(80) := g_package || '.archive_code';
4564: l_assignment_id pay_assignment_actions.assignment_id%type;
4565: l_business_group_id pay_payroll_actions.business_group_id%type ;
4566: l_registered_employer hr_organization_units.organization_id%type;
4567: l_current_le hr_organization_units.organization_id%type; --4363057
4568: l_payroll_action_id pay_payroll_actions.payroll_action_id%type ;

Line 4579: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;

4575: l_asg_start pay_payroll_actions.effective_date%type;
4576: l_asg_end pay_payroll_actions.effective_date%type;
4577: l_effective_date pay_payroll_actions.effective_date%type;
4578: l_death_benefit_type varchar2(100);
4579: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;
4580: l_max_assignment_action_id pay_assignment_actions.assignment_action_id%type;
4581: l_bbr_assignment_action_id pay_assignment_actions.assignment_action_id%type;
4582: l_fbt_assignment_action_id pay_assignment_actions.assignment_action_id%type; --2610141
4583: lump_sum_c_found boolean := false;

Line 4580: l_max_assignment_action_id pay_assignment_actions.assignment_action_id%type;

4576: l_asg_end pay_payroll_actions.effective_date%type;
4577: l_effective_date pay_payroll_actions.effective_date%type;
4578: l_death_benefit_type varchar2(100);
4579: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;
4580: l_max_assignment_action_id pay_assignment_actions.assignment_action_id%type;
4581: l_bbr_assignment_action_id pay_assignment_actions.assignment_action_id%type;
4582: l_fbt_assignment_action_id pay_assignment_actions.assignment_action_id%type; --2610141
4583: lump_sum_c_found boolean := false;
4584: l_final_process_date date; --263659

Line 4581: l_bbr_assignment_action_id pay_assignment_actions.assignment_action_id%type;

4577: l_effective_date pay_payroll_actions.effective_date%type;
4578: l_death_benefit_type varchar2(100);
4579: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;
4580: l_max_assignment_action_id pay_assignment_actions.assignment_action_id%type;
4581: l_bbr_assignment_action_id pay_assignment_actions.assignment_action_id%type;
4582: l_fbt_assignment_action_id pay_assignment_actions.assignment_action_id%type; --2610141
4583: lump_sum_c_found boolean := false;
4584: l_final_process_date date; --263659
4585: l_term_date varchar2(10); --3263659

Line 4582: l_fbt_assignment_action_id pay_assignment_actions.assignment_action_id%type; --2610141

4578: l_death_benefit_type varchar2(100);
4579: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;
4580: l_max_assignment_action_id pay_assignment_actions.assignment_action_id%type;
4581: l_bbr_assignment_action_id pay_assignment_actions.assignment_action_id%type;
4582: l_fbt_assignment_action_id pay_assignment_actions.assignment_action_id%type; --2610141
4583: lump_sum_c_found boolean := false;
4584: l_final_process_date date; --263659
4585: l_term_date varchar2(10); --3263659
4586: l_fetched_termination_date per_periods_of_service.actual_termination_date%TYPE; --3263659

Line 4614: from pay_assignment_actions paa

4610: , paa.assignment_id
4611: , to_date('01-07-'|| substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',ppa.legislative_parameters),1,4),'DD-MM-YYYY')
4612: , to_date('30-06-'|| substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',ppa.legislative_parameters),6,4),'DD-MM-YYYY')
4613: , pay_core_utils.get_parameter('LST_YR_TERM',ppa.legislative_parameters) /*Bug3661230*/
4614: from pay_assignment_actions paa
4615: , pay_payroll_actions ppa
4616: where paa.assignment_action_id = c_assignment_action_id
4617: and ppa.payroll_action_id = paa.payroll_action_id ;
4618: --

Line 4625: (c_assignment_id in pay_assignment_actions.assignment_id%type

4621: -- Bug 2856638 : added parameter c_business_group_id
4622: -------------------------------------------------+
4623: --
4624: cursor etp_code
4625: (c_assignment_id in pay_assignment_actions.assignment_id%type
4626: ,c_lst_year_start in pay_payroll_actions.effective_date%type --3263659
4627: ,c_year_start in pay_payroll_actions.effective_date%type
4628: ,c_year_end in pay_payroll_actions.effective_date%type
4629: ,c_def_bal_id in pay_defined_balances.defined_balance_id%type

Line 4643: pay_assignment_actions ppa

4639: per_all_assignments_f a,
4640: per_periods_of_service pps,
4641: pay_all_payrolls_f papf, --4281290
4642: pay_payroll_actions pa,
4643: pay_assignment_actions ppa
4644: where a.person_id = p.person_id
4645: and pps.person_id = p.person_id
4646: and a.assignment_id = ppa.assignment_id
4647: and papf.business_group_id = p.business_group_id --4281290

Line 4682: cursor cr_effective_date (c_assignment_action_id pay_assignment_actions.assignment_action_id%type) IS

4678: , pps.pds_information2
4679: , pps.final_process_date; --3263659
4680: --
4681: --3263659
4682: cursor cr_effective_date (c_assignment_action_id pay_assignment_actions.assignment_action_id%type) IS
4683: select ppa.effective_date
4684: from pay_payroll_actions ppa,
4685: pay_assignment_actions paa
4686: where paa.assignment_action_id = c_assignment_action_id

Line 4685: pay_assignment_actions paa

4681: --3263659
4682: cursor cr_effective_date (c_assignment_action_id pay_assignment_actions.assignment_action_id%type) IS
4683: select ppa.effective_date
4684: from pay_payroll_actions ppa,
4685: pay_assignment_actions paa
4686: where paa.assignment_action_id = c_assignment_action_id
4687: and ppa.payroll_action_id = paa.payroll_action_id;
4688: --
4689: -------------------------------------------------+

Line 4719: from pay_assignment_actions paa,

4715: ,c_year_end date
4716: ) is
4717: select to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) assignment_action_id,
4718: max(paa.action_sequence) action_sequence
4719: from pay_assignment_actions paa,
4720: pay_payroll_actions ppa,
4721: per_assignments_f paf
4722: where paa.assignment_id = paf.assignment_id
4723: and paf.assignment_id = c_assignment_id

Line 4766: from pay_assignment_actions paa,

4762: ,c_year_end pay_payroll_actions.effective_date%type
4763: ,c_legal_employer hr_organization_units.organization_id%type
4764: ) is
4765: select to_char(min(ppa.effective_date),'DDMMYYYY'), to_char(max(ppa.effective_date),'DDMMYYYY')
4766: from pay_assignment_actions paa,
4767: pay_payroll_actions ppa,
4768: per_assignments_f paaf
4769: where paa.assignment_id = paaf.assignment_id
4770: and paaf.assignment_id = c_assignment_id

Line 4815: l_bbr_action_sequence pay_assignment_actions.action_sequence%type; --3701869

4811: ---------------------------------------------------------------------------+
4812: --
4813: type bal_actual_type is table of varchar2(100) index by binary_integer;
4814: tab_bal_actual_name bal_actual_type ;
4815: l_bbr_action_sequence pay_assignment_actions.action_sequence%type; --3701869
4816:
4817: lv_trans_etp_flag varchar2(1);
4818: lv_part_of_prev_etp_flag varchar2(1);
4819:

Line 5588: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type)

5584: --------------------------------------------------------------------+
5585:
5586:
5587: function get_archive_value(p_user_entity_name in ff_user_entities.user_entity_name%type,
5588: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type)
5589: return varchar2 is
5590:
5591:
5592: -- cursor to fetch the archive value