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 1111: v_next_action_id pay_assignment_actions.assignment_action_id%type;

1107: p_end_person_id in per_all_people_f.person_id%type,
1108: p_chunk in number) is
1109:
1110:
1111: v_next_action_id pay_assignment_actions.assignment_action_id%type;
1112:
1113: v_lst_year_start date ;
1114: v_fbt_year_start date ;
1115: v_lst_fbt_year_start date ; --Bug#3661230

Line 1207: ,pay_assignment_actions rpac

1203: AND EXISTS
1204: (select /*+ ORDERED */''
1205: from
1206: per_assignments_f paaf
1207: ,pay_assignment_actions rpac
1208: ,pay_payroll_actions rppa
1209: where rppa.effective_date between v_fin_year_start and v_fin_year_end
1210: and rppa.action_type in ('R','Q','B','I')
1211: and rpac.tax_unit_id = v_reg_emp

Line 1222: ,pay_assignment_actions rpac

1218: UNION
1219: select /*+ ORDERED */''
1220: from
1221: per_assignments_f paaf
1222: ,pay_assignment_actions rpac
1223: ,pay_payroll_actions rppa
1224: where pps.actual_termination_date between v_lst_fbt_year_start and v_fbt_year_end /*Bug3263659 */ --Bug#3661230
1225: and rppa.effective_date between v_fbt_year_start and v_fbt_year_end
1226: and pay_balance_pkg.get_value(g_fbt_defined_balance_id,rpac.assignment_action_id

Line 1240: pay_assignment_actions paat,

1236: )
1237: and not exists
1238: (select distinct paat.assignment_id
1239: from pay_action_interlocks pail,
1240: pay_assignment_actions paat,
1241: pay_payroll_actions paas
1242: where paat.assignment_id = a.assignment_id
1243: and paas.action_type ='X'
1244: and paas.action_status ='C'

Line 1302: ,pay_assignment_actions rpac

1298: AND EXISTS
1299: (select /*+ ORDERED */''
1300: from
1301: per_assignments_f paaf
1302: ,pay_assignment_actions rpac
1303: ,pay_payroll_actions rppa
1304: where rppa.effective_date between v_fin_year_start and v_fin_year_end
1305: and rppa.action_type in ('R','Q','B','I')
1306: and rpac.tax_unit_id = v_reg_emp

Line 1317: ,pay_assignment_actions rpac

1313: UNION
1314: select /*+ ORDERED */''
1315: from
1316: per_assignments_f paaf
1317: ,pay_assignment_actions rpac
1318: ,pay_payroll_actions rppa
1319: where pps.actual_termination_date between v_lst_fbt_year_start and v_fbt_year_end /*Bug3263659 */ --Bug#3661230
1320: and rppa.effective_date between v_fbt_year_start and v_fbt_year_end
1321: and pay_balance_pkg.get_value(g_fbt_defined_balance_id,rpac.assignment_action_id

Line 1335: pay_assignment_actions paat,

1331: )
1332: and not exists
1333: (select distinct paat.assignment_id
1334: from pay_action_interlocks pail,
1335: pay_assignment_actions paat,
1336: pay_payroll_actions paas
1337: where paat.assignment_id = a.assignment_id
1338: and paas.action_type ='X'
1339: and paas.action_status ='C'

Line 1410: ,pay_assignment_actions rpac

1406: AND EXISTS
1407: (select /*+ ORDERED */''
1408: from
1409: per_assignments_f paaf
1410: ,pay_assignment_actions rpac
1411: ,pay_payroll_actions rppa
1412: where rppa.effective_date between v_fin_year_start and v_fin_year_end
1413: and rppa.action_type in ('R','Q','B','I')
1414: and rpac.tax_unit_id = v_reg_emp

Line 1425: ,pay_assignment_actions rpac

1421: UNION
1422: select /*+ ORDERED */''
1423: from
1424: per_assignments_f paaf
1425: ,pay_assignment_actions rpac
1426: ,pay_payroll_actions rppa
1427: where pps.actual_termination_date between v_lst_fbt_year_start and v_fbt_year_end /*Bug3263659 */ --Bug#3661230
1428: and rppa.effective_date between v_fbt_year_start and v_fbt_year_end
1429: and pay_balance_pkg.get_value(g_fbt_defined_balance_id,rpac.assignment_action_id

Line 1443: pay_assignment_actions paat,

1439: )
1440: AND NOT EXISTS
1441: (SELECT paat.assignment_id
1442: FROM pay_action_interlocks pail,
1443: pay_assignment_actions paat,
1444: pay_payroll_actions paas
1445: WHERE paat.assignment_id = a.assignment_id
1446: AND paas.action_type ='X'
1447: AND paas.action_status ='C'

Line 1468: select pay_assignment_actions_s.nextval

1464: AND meaning = v_financial_year
1465: );
1466:
1467: cursor next_action_id is
1468: select pay_assignment_actions_s.nextval
1469: from dual;
1470:
1471: /* Bug 5708255 */
1472: -------------------------------------------

Line 1549: ,pay_assignment_actions rpac

1545: AND EXISTS
1546: (select /*+ ORDERED */''
1547: from
1548: per_assignments_f paaf
1549: ,pay_assignment_actions rpac
1550: ,pay_payroll_actions rppa
1551: where rppa.effective_date between v_fin_year_start and v_fin_year_end
1552: and rppa.action_type in ('R','Q','B','I')
1553: and rpac.tax_unit_id = v_reg_emp

Line 1564: ,pay_assignment_actions rpac

1560: UNION
1561: select /*+ ORDERED */''
1562: from
1563: per_assignments_f paaf
1564: ,pay_assignment_actions rpac
1565: ,pay_payroll_actions rppa
1566: where pps.actual_termination_date between v_lst_fbt_year_start and v_fbt_year_end
1567: and rppa.effective_date between v_fbt_year_start and v_fbt_year_end
1568: and pay_balance_pkg.get_value(g_fbt_defined_balance_id,rpac.assignment_action_id

Line 1582: pay_assignment_actions paat,

1578: )
1579: AND NOT EXISTS
1580: (SELECT paat.assignment_id
1581: FROM pay_action_interlocks pail,
1582: pay_assignment_actions paat,
1583: pay_payroll_actions paas
1584: WHERE paat.assignment_id = a.assignment_id
1585: AND paas.action_type ='X'
1586: AND paas.action_status ='C'

Line 1646: ,pay_assignment_actions rpac

1642: AND EXISTS
1643: (select /*+ ORDERED */''
1644: from
1645: per_assignments_f paaf
1646: ,pay_assignment_actions rpac
1647: ,pay_payroll_actions rppa
1648: where rppa.effective_date between v_fin_year_start and v_fin_year_end
1649: and rppa.action_type in ('R','Q','B','I')
1650: and rpac.tax_unit_id = v_reg_emp

Line 1661: ,pay_assignment_actions rpac

1657: UNION
1658: select /*+ ORDERED */''
1659: from
1660: per_assignments_f paaf
1661: ,pay_assignment_actions rpac
1662: ,pay_payroll_actions rppa
1663: where pps.actual_termination_date between v_lst_fbt_year_start and v_fbt_year_end /*Bug3263659 */ --Bug#3661230
1664: and rppa.effective_date between v_fbt_year_start and v_fbt_year_end
1665: and pay_balance_pkg.get_value(g_fbt_defined_balance_id,rpac.assignment_action_id

Line 1679: pay_assignment_actions paat,

1675: )
1676: and not exists
1677: (select distinct paat.assignment_id
1678: from pay_action_interlocks pail,
1679: pay_assignment_actions paat,
1680: pay_payroll_actions paas
1681: where paat.assignment_id = a.assignment_id
1682: and paas.action_type ='X'
1683: and paas.action_status ='C'

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

2042: ------------------------------------------------------------------------+
2043:
2044:
2045: procedure create_extract_archive_details
2046: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
2047: p_user_entity_name in ff_user_entities.user_entity_name%type,
2048: p_value in out nocopy ff_archive_items.value%type) is
2049:
2050:

Line 2185: (p_assignment_action_id in pay_assignment_actions.ASSIGNMENT_ACTION_ID%TYPE

2181: -- Passed Balance name Bug #2454595
2182: ----------------------------------------------------------------------+
2183:
2184: procedure archive_balance_details
2185: (p_assignment_action_id in pay_assignment_actions.ASSIGNMENT_ACTION_ID%TYPE
2186: ,p_max_assignment_action_id in pay_assignment_actions.ASSIGNMENT_ACTION_ID%TYPE --2610141
2187: ,p_registered_employer in NUMBER
2188: ,p_database_item_name in ff_database_items.user_name%TYPE
2189: ,p_balance_name in pay_balance_types.balance_name%TYPE

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

2182: ----------------------------------------------------------------------+
2183:
2184: procedure archive_balance_details
2185: (p_assignment_action_id in pay_assignment_actions.ASSIGNMENT_ACTION_ID%TYPE
2186: ,p_max_assignment_action_id in pay_assignment_actions.ASSIGNMENT_ACTION_ID%TYPE --2610141
2187: ,p_registered_employer in NUMBER
2188: ,p_database_item_name in ff_database_items.user_name%TYPE
2189: ,p_balance_name in pay_balance_types.balance_name%TYPE
2190: ,p_legislation_code in pay_defined_balances.legislation_code%TYPE

Line 2193: ,p_assignment_id in pay_assignment_actions.ASSIGNMENT_ID%type

2189: ,p_balance_name in pay_balance_types.balance_name%TYPE
2190: ,p_legislation_code in pay_defined_balances.legislation_code%TYPE
2191: ,p_year_start in DATE
2192: ,p_year_end in DATE
2193: ,p_assignment_id in pay_assignment_actions.ASSIGNMENT_ID%type
2194: ,p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE
2195: ,p_bal_value OUT NOCOPY varchar2) IS -- Bug 3098353
2196:
2197: v_bal_value varchar2(20);

Line 2221: c_assignment_id pay_assignment_actions.assignment_id%type)

2217: -- Bug #2454595
2218: -------------------------------------------------------------------+
2219: cursor c_archive_fbt_info(c_balance_name pay_balance_types.balance_name%type,
2220: c_year_end DATE,
2221: c_assignment_id pay_assignment_actions.assignment_id%type)
2222: is
2223: select pay_balance_pkg.get_value(pdb.defined_balance_id,
2224: p_max_assignment_action_id,
2225: p_registered_employer,

Line 2698: ,p_assignment_id in pay_assignment_actions.ASSIGNMENT_ID%type

2694:
2695: function adjust_retro_allowances(t_allowance_balance IN OUT NOCOPY tab_allownace_balance
2696: ,p_year_start in DATE
2697: ,p_year_end in DATE
2698: ,p_assignment_id in pay_assignment_actions.ASSIGNMENT_ID%type
2699: ,p_registered_employer in NUMBER --2610141
2700: )
2701: return number
2702: is

Line 2709: c_assignment_id pay_assignment_actions.assignment_id%type)

2705: to accommodate Balance Attribute reporting
2706: */
2707: CURSOR Get_retro_Entry_ids(c_year_start DATE,
2708: c_year_end DATE,
2709: c_assignment_id pay_assignment_actions.assignment_id%type)
2710: IS
2711: SELECT /*+ ORDERED */ pee.element_entry_id element_entry_id,
2712: ppa.date_earned date_earned,
2713: pee.assignment_id assignment_id,

Line 2718: ,pay_assignment_actions pac

2714: pac.tax_unit_id, /* Added for bug #5846278 */
2715: pdb.balance_type_id
2716: FROM per_all_assignments_f paa
2717: ,per_periods_of_service pps
2718: ,pay_assignment_actions pac
2719: ,pay_payroll_actions ppa
2720: ,pay_element_entries_f pee
2721: ,pay_run_results prr
2722: ,pay_element_types_f pet

Line 3039: (p_assignment_id IN pay_assignment_actions.assignment_id%TYPE

3035: end loop;
3036: end archive_limited_values;
3037:
3038: PROCEDURE get_foreign_leave_payments
3039: (p_assignment_id IN pay_assignment_actions.assignment_id%TYPE
3040: ,p_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE
3041: ,p_start_date IN DATE
3042: ,p_end_date IN DATE
3043: ,p_leave_earnings OUT NOCOPY NUMBER

Line 3040: ,p_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE

3036: end archive_limited_values;
3037:
3038: PROCEDURE get_foreign_leave_payments
3039: (p_assignment_id IN pay_assignment_actions.assignment_id%TYPE
3040: ,p_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE
3041: ,p_start_date IN DATE
3042: ,p_end_date IN DATE
3043: ,p_leave_earnings OUT NOCOPY NUMBER
3044: ,p_leave_tax OUT NOCOPY NUMBER

Line 3049: (c_assignment_id pay_assignment_actions.assignment_id%TYPE

3045: )
3046: IS
3047:
3048: CURSOR get_max_action_id
3049: (c_assignment_id pay_assignment_actions.assignment_id%TYPE
3050: ,c_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE
3051: ,c_start_date DATE
3052: ,c_end_date DATE
3053: )

Line 3050: ,c_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE

3046: IS
3047:
3048: CURSOR get_max_action_id
3049: (c_assignment_id pay_assignment_actions.assignment_id%TYPE
3050: ,c_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE
3051: ,c_start_date DATE
3052: ,c_end_date DATE
3053: )
3054: IS

Line 3059: FROM pay_assignment_actions paa,

3055: SELECT TO_NUMBER(SUBSTR(MAX(LPAD(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) assignment_action_id
3056: ,ptp.start_date
3057: ,ptp.end_date
3058: ,MAX(paa.action_sequence) action_sequence
3059: FROM pay_assignment_actions paa,
3060: pay_payroll_actions ppa,
3061: per_assignments_f paf,
3062: per_time_periods ptp
3063: WHERE paa.assignment_id = paf.assignment_id

Line 3281: (p_assignment_id in pay_assignment_actions.ASSIGNMENT_ID%type

3277:
3278: */
3279: ----------------------------------------------------------------------------
3280: procedure archive_fw_details
3281: (p_assignment_id in pay_assignment_actions.ASSIGNMENT_ID%type
3282: ,p_registered_employer in NUMBER
3283: ,p_assignment_action_id in pay_assignment_actions.assignment_action_id%type
3284: ,p_year_start in DATE
3285: ,p_year_end in DATE

Line 3283: ,p_assignment_action_id in pay_assignment_actions.assignment_action_id%type

3279: ----------------------------------------------------------------------------
3280: procedure archive_fw_details
3281: (p_assignment_id in pay_assignment_actions.ASSIGNMENT_ID%type
3282: ,p_registered_employer in NUMBER
3283: ,p_assignment_action_id in pay_assignment_actions.assignment_action_id%type
3284: ,p_year_start in DATE
3285: ,p_year_end in DATE
3286: ,p_fw_check in varchar2
3287: ,p_actual_termination_date in per_periods_of_service.actual_termination_date%TYPE

Line 4189: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type

4185: --* Archive Allowance details
4186: -----------------------------
4187:
4188: procedure archive_allowance_details
4189: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type
4190: ,p_max_assignment_action_id in pay_assignment_actions.assignment_action_id%type
4191: ,p_registered_employer in number
4192: ,p_year_start in date
4193: ,p_year_end in date

Line 4190: ,p_max_assignment_action_id in pay_assignment_actions.assignment_action_id%type

4186: -----------------------------
4187:
4188: procedure archive_allowance_details
4189: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type
4190: ,p_max_assignment_action_id in pay_assignment_actions.assignment_action_id%type
4191: ,p_registered_employer in number
4192: ,p_year_start in date
4193: ,p_year_end in date
4194: ,p_assignment_id in pay_assignment_actions.assignment_id%type

Line 4194: ,p_assignment_id in pay_assignment_actions.assignment_id%type

4190: ,p_max_assignment_action_id in pay_assignment_actions.assignment_action_id%type
4191: ,p_registered_employer in number
4192: ,p_year_start in date
4193: ,p_year_end in date
4194: ,p_assignment_id in pay_assignment_actions.assignment_id%type
4195: ,p_alw_bal_exist out nocopy varchar2 -- 3098353
4196: ) IS
4197: l_procedure constant varchar2(80) := g_package||'.archive_allowance_details';
4198:

Line 4426: ( p_assignment_action_id pay_assignment_actions.assignment_action_id%type,

4422: -- X_ETP_EMPLOYEE_PAYMENT_DATE
4423: -----------------------------------------------------------
4424:
4425: procedure archive_etp_payment_details
4426: ( p_assignment_action_id pay_assignment_actions.assignment_action_id%type,
4427: p_registered_employer NUMBER, --2610141
4428: p_assignment_id per_all_Assignments_f.assignment_id%type ,
4429: p_year_start date,
4430: p_year_end date ) as

Line 4446: ,pay_assignment_actions pac

4442: ,pay_input_values_f piv
4443: ,per_all_assignments_f paa
4444: ,pay_run_results prr
4445: ,pay_run_result_values prv
4446: ,pay_assignment_actions pac
4447: ,pay_payroll_actions ppa
4448: ,pay_payrolls_f papf /* bug Number 4278361 */
4449: where pet.element_type_id = piv.element_type_id
4450: and pet.element_name = 'ETP on Termination'

Line 4474: (c_assignment_action_id pay_assignment_actions.assignment_action_id%type,

4470: and c_year_end
4471: and pac.tax_unit_id = p_registered_employer; --2610141
4472:
4473: cursor etp_prepayment
4474: (c_assignment_action_id pay_assignment_actions.assignment_action_id%type,
4475: c_payroll_action_id pay_payroll_actions.payroll_action_id%type,
4476: c_year_start date,
4477: c_year_end date )
4478: is select to_char(pppa.effective_date,'DDMMYYYY')

Line 4480: ,pay_assignment_actions pac

4476: c_year_start date,
4477: c_year_end date )
4478: is select to_char(pppa.effective_date,'DDMMYYYY')
4479: from pay_action_interlocks pai
4480: ,pay_assignment_actions pac
4481: ,pay_payroll_actions ppa
4482: ,pay_assignment_actions ppac
4483: ,pay_payroll_actions pppa
4484: where pac.payroll_action_id = ppa.payroll_action_id

Line 4482: ,pay_assignment_actions ppac

4478: is select to_char(pppa.effective_date,'DDMMYYYY')
4479: from pay_action_interlocks pai
4480: ,pay_assignment_actions pac
4481: ,pay_payroll_actions ppa
4482: ,pay_assignment_actions ppac
4483: ,pay_payroll_actions pppa
4484: where pac.payroll_action_id = ppa.payroll_action_id
4485: and pac.assignment_action_id = c_assignment_action_id
4486: and pac.assignment_action_id = pai.locked_action_id

Line 4506: ,pay_assignment_actions pac

4502: c_year_end date )
4503: is select max(ppa.payroll_action_id) payroll_action_id
4504: ,max(pac.assignment_action_id) assignment_action_id
4505: from per_assignments_f paf
4506: ,pay_assignment_actions pac
4507: ,pay_payroll_actions ppa
4508: where pac.assignment_id = c_assignment_id
4509: and pac.tax_unit_id = p_registered_employer --2610141
4510: and paf.assignment_id = pac.assignment_id

Line 4628: ,p_assignment_action_id in pay_assignment_actions.assignment_action_id%type

4624: -- bug9147430 :
4625: -- when the logic is changed, archive_fw_details should be modified together.
4626: procedure archive_2006_unions
4627: (p_assignment_id in per_all_assignments.assignment_id%type
4628: ,p_assignment_action_id in pay_assignment_actions.assignment_action_id%type
4629: ,p_max_assignment_action_id in pay_assignment_actions.assignment_action_id%type
4630: ,p_registered_employer in number
4631: ,p_year_start in date
4632: ,p_year_end in date

Line 4629: ,p_max_assignment_action_id in pay_assignment_actions.assignment_action_id%type

4625: -- when the logic is changed, archive_fw_details should be modified together.
4626: procedure archive_2006_unions
4627: (p_assignment_id in per_all_assignments.assignment_id%type
4628: ,p_assignment_action_id in pay_assignment_actions.assignment_action_id%type
4629: ,p_max_assignment_action_id in pay_assignment_actions.assignment_action_id%type
4630: ,p_registered_employer in number
4631: ,p_year_start in date
4632: ,p_year_end in date
4633: --,p_alw_bal_exist out nocopy varchar2

Line 4652: , pay_assignment_actions pac

4648: , per_all_assignments_f paa
4649: , pay_balance_types pbt
4650: , pay_defined_balances pdb
4651: , pay_payroll_actions ppa
4652: , pay_assignment_actions pac
4653: , pay_run_results prr
4654: , pay_balance_feeds_f pbf
4655: , pay_input_values_f piv
4656: where pac.assignment_id = p_assignment_id

Line 4921: ,p_assignment_action_id in pay_assignment_actions.assignment_action_id%type

4917: -- bug9147430
4918: -- When the logic is changed, archive_fw_details should be modified together.
4919: procedure archive_union_name
4920: (p_assignment_id in per_all_assignments.assignment_id%type
4921: ,p_assignment_action_id in pay_assignment_actions.assignment_action_id%type
4922: ,p_max_assignment_action_id in pay_assignment_actions.assignment_action_id%type
4923: ,p_registered_employer number
4924: ,p_year_start in date
4925: ,p_year_end in date

Line 4922: ,p_max_assignment_action_id in pay_assignment_actions.assignment_action_id%type

4918: -- When the logic is changed, archive_fw_details should be modified together.
4919: procedure archive_union_name
4920: (p_assignment_id in per_all_assignments.assignment_id%type
4921: ,p_assignment_action_id in pay_assignment_actions.assignment_action_id%type
4922: ,p_max_assignment_action_id in pay_assignment_actions.assignment_action_id%type
4923: ,p_registered_employer number
4924: ,p_year_start in date
4925: ,p_year_end in date
4926: ) as

Line 5108: p_assignment_Action_id in pay_assignment_actions.assignment_action_id%type,

5104: Procedure archive_etp_details
5105: (p_business_group_id in hr_organization_units.business_group_id%type,
5106: p_registered_employer in hr_organization_units.organization_id%type,
5107: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
5108: p_assignment_Action_id in pay_assignment_actions.assignment_action_id%type,
5109: p_assignment_id in pay_assignment_actions.assignment_id%type,
5110: p_year_start in pay_payroll_actions.effective_date%type,
5111: p_year_end in pay_payroll_Actions.effective_date%type,
5112: p_lst_year_start in pay_payroll_Actions.effective_date%type,/*Bug3661230 Added one extra parameter*/

Line 5109: p_assignment_id in pay_assignment_actions.assignment_id%type,

5105: (p_business_group_id in hr_organization_units.business_group_id%type,
5106: p_registered_employer in hr_organization_units.organization_id%type,
5107: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
5108: p_assignment_Action_id in pay_assignment_actions.assignment_action_id%type,
5109: p_assignment_id in pay_assignment_actions.assignment_id%type,
5110: p_year_start in pay_payroll_actions.effective_date%type,
5111: p_year_end in pay_payroll_Actions.effective_date%type,
5112: p_lst_year_start in pay_payroll_Actions.effective_date%type,/*Bug3661230 Added one extra parameter*/
5113: p_transitional_flag out nocopy varchar2, /*Bug 6192381 Added New Parameters p_transitional_flag and p_part_prev_etp_flag */

Line 5144: c_assignment_id in pay_assignment_actions.assignment_id%type,

5140: /*Bug 8315198 - Modified cursor to fetch the Tax file number entered in termination form for employees recieving Death Benefit ETP */
5141: cursor etp_details( c_business_group_id in hr_organization_units.business_group_id%type,
5142: c_registered_employer in hr_organization_units.organization_id%type,
5143: c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
5144: c_assignment_id in pay_assignment_actions.assignment_id%type,
5145: c_year_start in pay_payroll_actions.effective_date%type,
5146: c_year_end in pay_payroll_Actions.effective_date%type)
5147: is
5148: select pev.screen_entry_value tax_file_number

Line 5183: pay_assignment_actions pac,

5179: per_addresses pad,
5180: fnd_territories_tl fta,
5181: per_periods_of_service pps,
5182: pay_payroll_actions ppa,
5183: pay_assignment_actions pac,
5184: hr_locations_all hlc /* Bug No : 2263587 */
5185: where hou.business_group_id = c_business_group_id
5186: and hou.organization_id = c_registered_employer
5187: and ppa.action_type = 'X'

Line 5243: ,pay_assignment_actions pac

5239: ,pay_input_values_f piv
5240: ,per_all_assignments_f paa
5241: ,pay_run_results prr
5242: ,pay_run_result_values prv
5243: ,pay_assignment_actions pac
5244: ,pay_payroll_actions ppa
5245: where pet.element_type_id = piv.element_type_id
5246: and pet.element_name = 'ETP on Termination'
5247: and piv.name in ('Transitional ETP','Part of Previously Paid ETP')

Line 5443: (p_assignment_action_id in pay_assignment_actions.ASSIGNMENT_ACTION_ID%TYPE

5439: ---------------------------------------------------------------------+
5440:
5441:
5442: procedure archive_prepost_details
5443: (p_assignment_action_id in pay_assignment_actions.ASSIGNMENT_ACTION_ID%TYPE
5444: ,p_max_assignment_action_id in pay_assignment_actions.ASSIGNMENT_ACTION_ID%TYPE --2610141
5445: ,p_registered_employer in pay_assignment_actions.TAX_UNIT_ID%TYPE --2610141
5446: ,p_legislation_code in pay_defined_balances.legislation_code%TYPE
5447: ,p_assignment_id in pay_assignment_actions.ASSIGNMENT_ID%type

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

5440:
5441:
5442: procedure archive_prepost_details
5443: (p_assignment_action_id in pay_assignment_actions.ASSIGNMENT_ACTION_ID%TYPE
5444: ,p_max_assignment_action_id in pay_assignment_actions.ASSIGNMENT_ACTION_ID%TYPE --2610141
5445: ,p_registered_employer in pay_assignment_actions.TAX_UNIT_ID%TYPE --2610141
5446: ,p_legislation_code in pay_defined_balances.legislation_code%TYPE
5447: ,p_assignment_id in pay_assignment_actions.ASSIGNMENT_ID%type
5448: ,p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE

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

5441:
5442: procedure archive_prepost_details
5443: (p_assignment_action_id in pay_assignment_actions.ASSIGNMENT_ACTION_ID%TYPE
5444: ,p_max_assignment_action_id in pay_assignment_actions.ASSIGNMENT_ACTION_ID%TYPE --2610141
5445: ,p_registered_employer in pay_assignment_actions.TAX_UNIT_ID%TYPE --2610141
5446: ,p_legislation_code in pay_defined_balances.legislation_code%TYPE
5447: ,p_assignment_id in pay_assignment_actions.ASSIGNMENT_ID%type
5448: ,p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE
5449: ,p_actual_termination_date in per_periods_of_service.actual_termination_date%TYPE

Line 5447: ,p_assignment_id in pay_assignment_actions.ASSIGNMENT_ID%type

5443: (p_assignment_action_id in pay_assignment_actions.ASSIGNMENT_ACTION_ID%TYPE
5444: ,p_max_assignment_action_id in pay_assignment_actions.ASSIGNMENT_ACTION_ID%TYPE --2610141
5445: ,p_registered_employer in pay_assignment_actions.TAX_UNIT_ID%TYPE --2610141
5446: ,p_legislation_code in pay_defined_balances.legislation_code%TYPE
5447: ,p_assignment_id in pay_assignment_actions.ASSIGNMENT_ID%type
5448: ,p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE
5449: ,p_actual_termination_date in per_periods_of_service.actual_termination_date%TYPE
5450: ,p_date_start in per_periods_of_service.date_start%TYPE
5451: ,p_year_start in pay_payroll_actions.effective_date%type

Line 5980: (p_assignment_action_id in pay_assignment_actions.ASSIGNMENT_ACTION_ID%TYPE

5976: 5) Adjust etp balances according to etp payment date
5977: 6) Archive the adjusted balance values
5978: */
5979: procedure archive_prepost_details_2012
5980: (p_assignment_action_id in pay_assignment_actions.ASSIGNMENT_ACTION_ID%TYPE
5981: ,p_max_assignment_action_id in pay_assignment_actions.ASSIGNMENT_ACTION_ID%TYPE --2610141
5982: ,p_registered_employer in pay_assignment_actions.TAX_UNIT_ID%TYPE --2610141
5983: ,p_legislation_code in pay_defined_balances.legislation_code%TYPE
5984: ,p_assignment_id in pay_assignment_actions.ASSIGNMENT_ID%type

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

5977: 6) Archive the adjusted balance values
5978: */
5979: procedure archive_prepost_details_2012
5980: (p_assignment_action_id in pay_assignment_actions.ASSIGNMENT_ACTION_ID%TYPE
5981: ,p_max_assignment_action_id in pay_assignment_actions.ASSIGNMENT_ACTION_ID%TYPE --2610141
5982: ,p_registered_employer in pay_assignment_actions.TAX_UNIT_ID%TYPE --2610141
5983: ,p_legislation_code in pay_defined_balances.legislation_code%TYPE
5984: ,p_assignment_id in pay_assignment_actions.ASSIGNMENT_ID%type
5985: ,p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE

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

5978: */
5979: procedure archive_prepost_details_2012
5980: (p_assignment_action_id in pay_assignment_actions.ASSIGNMENT_ACTION_ID%TYPE
5981: ,p_max_assignment_action_id in pay_assignment_actions.ASSIGNMENT_ACTION_ID%TYPE --2610141
5982: ,p_registered_employer in pay_assignment_actions.TAX_UNIT_ID%TYPE --2610141
5983: ,p_legislation_code in pay_defined_balances.legislation_code%TYPE
5984: ,p_assignment_id in pay_assignment_actions.ASSIGNMENT_ID%type
5985: ,p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE
5986: ,p_actual_termination_date in per_periods_of_service.actual_termination_date%TYPE

Line 5984: ,p_assignment_id in pay_assignment_actions.ASSIGNMENT_ID%type

5980: (p_assignment_action_id in pay_assignment_actions.ASSIGNMENT_ACTION_ID%TYPE
5981: ,p_max_assignment_action_id in pay_assignment_actions.ASSIGNMENT_ACTION_ID%TYPE --2610141
5982: ,p_registered_employer in pay_assignment_actions.TAX_UNIT_ID%TYPE --2610141
5983: ,p_legislation_code in pay_defined_balances.legislation_code%TYPE
5984: ,p_assignment_id in pay_assignment_actions.ASSIGNMENT_ID%type
5985: ,p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE
5986: ,p_actual_termination_date in per_periods_of_service.actual_termination_date%TYPE
5987: ,p_date_start in per_periods_of_service.date_start%TYPE
5988: ,p_year_start in pay_payroll_actions.effective_date%type

Line 5998: ,pay_assignment_actions pac

5994: ,pac.assignment_action_id
5995: ,ppa.payroll_action_id
5996: FROM pay_run_results prr
5997: ,per_all_assignments_f paaf
5998: ,pay_assignment_actions pac
5999: ,pay_payroll_actions ppa
6000: ,pay_payrolls_f papf
6001: ,pay_element_types_f pet
6002: WHERE pac.assignment_id = p_assignment_id

Line 6021: (c_assignment_action_id pay_assignment_actions.assignment_action_id%type,

6017: AND ppa.effective_date between paaf.effective_start_date and paaf.effective_end_date
6018: order by pet.element_name, pac.assignment_action_id;
6019:
6020: cursor etp_prepayment
6021: (c_assignment_action_id pay_assignment_actions.assignment_action_id%type,
6022: c_payroll_action_id pay_payroll_actions.payroll_action_id%type) is
6023: select to_char(pppa.effective_date,'DDMMYYYY')
6024: from pay_action_interlocks pai
6025: ,pay_assignment_actions pac

Line 6025: ,pay_assignment_actions pac

6021: (c_assignment_action_id pay_assignment_actions.assignment_action_id%type,
6022: c_payroll_action_id pay_payroll_actions.payroll_action_id%type) is
6023: select to_char(pppa.effective_date,'DDMMYYYY')
6024: from pay_action_interlocks pai
6025: ,pay_assignment_actions pac
6026: ,pay_payroll_actions ppa
6027: ,pay_assignment_actions ppac
6028: ,pay_payroll_actions pppa
6029: where pac.payroll_action_id = ppa.payroll_action_id

Line 6027: ,pay_assignment_actions ppac

6023: select to_char(pppa.effective_date,'DDMMYYYY')
6024: from pay_action_interlocks pai
6025: ,pay_assignment_actions pac
6026: ,pay_payroll_actions ppa
6027: ,pay_assignment_actions ppac
6028: ,pay_payroll_actions pppa
6029: where pac.payroll_action_id = ppa.payroll_action_id
6030: and pac.assignment_action_id = c_assignment_action_id
6031: and pac.assignment_action_id = pai.locked_action_id

Line 6043: ,pay_assignment_actions pac

6039: select ppa.payroll_action_id
6040: ,pac.assignment_action_id
6041: ,to_char(ppa.effective_date,'DDMMYYYY') run_effective_date
6042: from per_assignments_f paf
6043: ,pay_assignment_actions pac
6044: ,pay_payroll_actions ppa
6045: where pac.assignment_id = p_assignment_id
6046: and pac.tax_unit_id = p_registered_employer
6047: and paf.assignment_id = pac.assignment_id

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

6952: ---------------------------------------------------------------------------------------+
6953:
6954: Procedure archive_employer_details
6955: (p_business_group_id in hr_organization_units.business_group_id%type,
6956: p_max_assignment_action_id in pay_assignment_actions.assignment_action_id%TYPE, --2610141
6957: p_registered_employer in hr_organization_units.organization_id%type,
6958: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
6959: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
6960: p_assignment_id in pay_assignment_actions.assignment_id%type,

Line 6959: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,

6955: (p_business_group_id in hr_organization_units.business_group_id%type,
6956: p_max_assignment_action_id in pay_assignment_actions.assignment_action_id%TYPE, --2610141
6957: p_registered_employer in hr_organization_units.organization_id%type,
6958: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
6959: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
6960: p_assignment_id in pay_assignment_actions.assignment_id%type,
6961: p_year_start in pay_payroll_actions.effective_date%type,
6962: p_year_end in pay_payroll_Actions.effective_date%type) is
6963:

Line 6960: p_assignment_id in pay_assignment_actions.assignment_id%type,

6956: p_max_assignment_action_id in pay_assignment_actions.assignment_action_id%TYPE, --2610141
6957: p_registered_employer in hr_organization_units.organization_id%type,
6958: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
6959: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
6960: p_assignment_id in pay_assignment_actions.assignment_id%type,
6961: p_year_start in pay_payroll_actions.effective_date%type,
6962: p_year_end in pay_payroll_Actions.effective_date%type) is
6963:
6964:

Line 7183: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,

7179: Procedure archive_employee_details
7180: (p_business_group_id in hr_organization_units.business_group_id%type,
7181: p_registered_employer in hr_organization_units.organization_id%type,
7182: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
7183: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
7184: p_assignment_id in pay_assignment_actions.assignment_id%type,
7185: p_year_start in pay_payroll_actions.effective_date%type,
7186: p_year_end in pay_payroll_Actions.effective_date%type,
7187: p_end_date_flag in varchar2,

Line 7184: p_assignment_id in pay_assignment_actions.assignment_id%type,

7180: (p_business_group_id in hr_organization_units.business_group_id%type,
7181: p_registered_employer in hr_organization_units.organization_id%type,
7182: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
7183: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
7184: p_assignment_id in pay_assignment_actions.assignment_id%type,
7185: p_year_start in pay_payroll_actions.effective_date%type,
7186: p_year_end in pay_payroll_Actions.effective_date%type,
7187: p_end_date_flag in varchar2,
7188: p_fbt_year_start IN pay_payroll_Actions.effective_date%type) is /*Bug# 4653934*/

Line 7320: pay_assignment_actions pac,

7316: per_addresses pad,
7317: fnd_territories_tl fta,
7318: per_periods_of_service pps,
7319: pay_payroll_actions ppa,
7320: pay_assignment_actions pac,
7321: pay_payroll_actions ppa1, /* Bug# 2448441 */
7322: pay_assignment_actions pac1 /* Bug# 2448441 */
7323: where hou.business_group_id = p_business_group_id
7324: and hou.organization_id = p_registered_employer

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

7318: per_periods_of_service pps,
7319: pay_payroll_actions ppa,
7320: pay_assignment_actions pac,
7321: pay_payroll_actions ppa1, /* Bug# 2448441 */
7322: pay_assignment_actions pac1 /* Bug# 2448441 */
7323: where hou.business_group_id = p_business_group_id
7324: and hou.organization_id = p_registered_employer
7325: and ppa.action_type = 'X'
7326: and hou.organization_id = hoi.organization_id

Line 7349: pay_assignment_actions paa2

7345: and paa.assignment_id = pac1.assignment_id
7346: and ppa1.payroll_action_id = pac1.payroll_action_id
7347: and pac1.assignment_action_id = (select to_number(substr(max(lpad(paa2.action_sequence,15,'0')||paa2.assignment_action_id),16)) /*Bug 7242551 */
7348: from pay_payroll_actions ppa2,
7349: pay_assignment_actions paa2
7350: where ppa2.action_type in ('R','Q','B','I') --Bug 2574186
7351: and ppa2.payroll_action_id = paa2.payroll_action_id
7352: and paa2.tax_unit_id = p_registered_employer -- Bug 2610141
7353: and paa2.assignment_id = paa.assignment_id

Line 7725: p_assignment_Action_id in pay_assignment_actions.assignment_action_id%type,

7721: Procedure archive_supplier_details
7722: (p_business_group_id in hr_organization_units.business_group_id%type,
7723: p_registered_employer in hr_organization_units.organization_id%type,
7724: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
7725: p_assignment_Action_id in pay_assignment_actions.assignment_action_id%type,
7726: p_assignment_id in pay_assignment_actions.assignment_id%type,
7727: p_year_start in pay_payroll_actions.effective_date%type,
7728: p_year_end in pay_payroll_Actions.effective_date%type) is
7729:

Line 7726: p_assignment_id in pay_assignment_actions.assignment_id%type,

7722: (p_business_group_id in hr_organization_units.business_group_id%type,
7723: p_registered_employer in hr_organization_units.organization_id%type,
7724: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
7725: p_assignment_Action_id in pay_assignment_actions.assignment_action_id%type,
7726: p_assignment_id in pay_assignment_actions.assignment_id%type,
7727: p_year_start in pay_payroll_actions.effective_date%type,
7728: p_year_end in pay_payroll_Actions.effective_date%type) is
7729:
7730:

Line 8021: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type

8017: -- 5. archive_supplier_details
8018: -- 6. archive_employee_details
8019: --------------------------------------------------------------------+
8020: procedure archive_code
8021: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type
8022: ,p_effective_date in date
8023: ) is
8024: --
8025: l_procedure constant varchar2(80) := g_package || '.archive_code';

Line 8026: l_assignment_id pay_assignment_actions.assignment_id%type;

8022: ,p_effective_date in date
8023: ) is
8024: --
8025: l_procedure constant varchar2(80) := g_package || '.archive_code';
8026: l_assignment_id pay_assignment_actions.assignment_id%type;
8027: l_business_group_id pay_payroll_actions.business_group_id%type ;
8028: l_registered_employer hr_organization_units.organization_id%type;
8029: l_current_le hr_organization_units.organization_id%type; --4363057
8030: l_payroll_action_id pay_payroll_actions.payroll_action_id%type ;

Line 8041: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;

8037: l_asg_start pay_payroll_actions.effective_date%type;
8038: l_asg_end pay_payroll_actions.effective_date%type;
8039: l_effective_date pay_payroll_actions.effective_date%type;
8040: l_death_benefit_type varchar2(100);
8041: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;
8042: l_max_assignment_action_id pay_assignment_actions.assignment_action_id%type;
8043: l_bbr_assignment_action_id pay_assignment_actions.assignment_action_id%type;
8044: l_fbt_assignment_action_id pay_assignment_actions.assignment_action_id%type; --2610141
8045: lump_sum_c_found boolean := false;

Line 8042: l_max_assignment_action_id pay_assignment_actions.assignment_action_id%type;

8038: l_asg_end pay_payroll_actions.effective_date%type;
8039: l_effective_date pay_payroll_actions.effective_date%type;
8040: l_death_benefit_type varchar2(100);
8041: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;
8042: l_max_assignment_action_id pay_assignment_actions.assignment_action_id%type;
8043: l_bbr_assignment_action_id pay_assignment_actions.assignment_action_id%type;
8044: l_fbt_assignment_action_id pay_assignment_actions.assignment_action_id%type; --2610141
8045: lump_sum_c_found boolean := false;
8046: l_final_process_date date; --263659

Line 8043: l_bbr_assignment_action_id pay_assignment_actions.assignment_action_id%type;

8039: l_effective_date pay_payroll_actions.effective_date%type;
8040: l_death_benefit_type varchar2(100);
8041: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;
8042: l_max_assignment_action_id pay_assignment_actions.assignment_action_id%type;
8043: l_bbr_assignment_action_id pay_assignment_actions.assignment_action_id%type;
8044: l_fbt_assignment_action_id pay_assignment_actions.assignment_action_id%type; --2610141
8045: lump_sum_c_found boolean := false;
8046: l_final_process_date date; --263659
8047: l_term_date varchar2(10); --3263659

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

8040: l_death_benefit_type varchar2(100);
8041: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;
8042: l_max_assignment_action_id pay_assignment_actions.assignment_action_id%type;
8043: l_bbr_assignment_action_id pay_assignment_actions.assignment_action_id%type;
8044: l_fbt_assignment_action_id pay_assignment_actions.assignment_action_id%type; --2610141
8045: lump_sum_c_found boolean := false;
8046: l_final_process_date date; --263659
8047: l_term_date varchar2(10); --3263659
8048: l_fetched_termination_date per_periods_of_service.actual_termination_date%TYPE; --3263659

Line 8079: from pay_assignment_actions paa

8075: , paa.assignment_id
8076: , to_date('01-07-'|| substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',ppa.legislative_parameters),1,4),'DD-MM-YYYY')
8077: , to_date('30-06-'|| substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',ppa.legislative_parameters),6,4),'DD-MM-YYYY')
8078: , pay_core_utils.get_parameter('LST_YR_TERM',ppa.legislative_parameters) /*Bug3661230*/
8079: from pay_assignment_actions paa
8080: , pay_payroll_actions ppa
8081: where paa.assignment_action_id = c_assignment_action_id
8082: and ppa.payroll_action_id = paa.payroll_action_id ;
8083: --

Line 8090: (c_assignment_id in pay_assignment_actions.assignment_id%type

8086: -- Bug 2856638 : added parameter c_business_group_id
8087: -------------------------------------------------+
8088: --
8089: cursor etp_code
8090: (c_assignment_id in pay_assignment_actions.assignment_id%type
8091: ,c_lst_year_start in pay_payroll_actions.effective_date%type --3263659
8092: ,c_year_start in pay_payroll_actions.effective_date%type
8093: ,c_year_end in pay_payroll_actions.effective_date%type
8094: ,c_def_bal_id in pay_defined_balances.defined_balance_id%type

Line 8108: pay_assignment_actions ppa

8104: per_all_assignments_f a,
8105: per_periods_of_service pps,
8106: pay_all_payrolls_f papf, --4281290
8107: pay_payroll_actions pa,
8108: pay_assignment_actions ppa
8109: where a.person_id = p.person_id
8110: and pps.person_id = p.person_id
8111: and a.assignment_id = ppa.assignment_id
8112: and papf.business_group_id = p.business_group_id --4281290

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

8147: , pps.pds_information2
8148: , pps.final_process_date; --3263659
8149: --
8150: --3263659
8151: cursor cr_effective_date (c_assignment_action_id pay_assignment_actions.assignment_action_id%type) IS
8152: select ppa.effective_date
8153: from pay_payroll_actions ppa,
8154: pay_assignment_actions paa
8155: where paa.assignment_action_id = c_assignment_action_id

Line 8154: pay_assignment_actions paa

8150: --3263659
8151: cursor cr_effective_date (c_assignment_action_id pay_assignment_actions.assignment_action_id%type) IS
8152: select ppa.effective_date
8153: from pay_payroll_actions ppa,
8154: pay_assignment_actions paa
8155: where paa.assignment_action_id = c_assignment_action_id
8156: and ppa.payroll_action_id = paa.payroll_action_id;
8157: --
8158: -------------------------------------------------+

Line 8189: from pay_assignment_actions paa,

8185: ,c_year_end date
8186: ) is
8187: select to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) assignment_action_id,
8188: max(paa.action_sequence) action_sequence
8189: from pay_assignment_actions paa,
8190: pay_payroll_actions ppa,
8191: per_assignments_f paf
8192: where paa.assignment_id = paf.assignment_id
8193: and paf.assignment_id = c_assignment_id

Line 8237: from pay_assignment_actions paa,

8233: ,c_year_end pay_payroll_actions.effective_date%type
8234: ,c_legal_employer hr_organization_units.organization_id%type
8235: ) is
8236: select to_char(min(ppa.effective_date),'DDMMYYYY'), to_char(max(ppa.effective_date),'DDMMYYYY')
8237: from pay_assignment_actions paa,
8238: pay_payroll_actions ppa,
8239: per_assignments_f paaf
8240: where paa.assignment_id = paaf.assignment_id
8241: and paaf.assignment_id = c_assignment_id

Line 8276: FROM pay_assignment_actions paa,

8272: ,c_year_start DATE
8273: ,c_year_end DATE
8274: ) is
8275: SELECT max(ppa.effective_date) effective_date
8276: FROM pay_assignment_actions paa,
8277: pay_payroll_actions ppa,
8278: per_assignments_f paf,
8279: pay_element_types_f pet,
8280: pay_run_results prr

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

8313: ---------------------------------------------------------------------------+
8314: --
8315: type bal_actual_type is table of varchar2(100) index by binary_integer;
8316: tab_bal_actual_name bal_actual_type ;
8317: l_bbr_action_sequence pay_assignment_actions.action_sequence%type; --3701869
8318:
8319: lv_trans_etp_flag varchar2(1);
8320: lv_part_of_prev_etp_flag varchar2(1);
8321:

Line 9328: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type)

9324: --------------------------------------------------------------------+
9325:
9326:
9327: function get_archive_value(p_user_entity_name in ff_user_entities.user_entity_name%type,
9328: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type)
9329: return varchar2 is
9330:
9331:
9332: -- cursor to fetch the archive value

Line 9504: ,p_assignment_id in pay_assignment_actions.ASSIGNMENT_ID%type

9500:
9501: /*bug8711855 - The function adjusts Lump Sum E balance by less than 400 PTD value*/
9502: function get_lumpsumE_value
9503: (p_registered_employer in NUMBER
9504: ,p_assignment_id in pay_assignment_actions.ASSIGNMENT_ID%type
9505: ,p_year_start in DATE
9506: ,p_year_end in DATE
9507: ,p_lump_sum_E_ptd_tab in pay_balance_pkg.t_balance_value_tab
9508: ,p_lump_sum_E_ytd in number

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

9514: can be taken into account while calculating payment summary gross.*/
9515: /*Bug 8441044 - Cursor is modified to include action types 'B' and 'I', so that when Lump Sum E payments are
9516: fed through Balance adjustment and Balance initialization processes,Lump Sum E Payments are
9517: taken into account for calculating payment summary gross */
9518: CURSOR c_get_pay_effective_date(c_assignment_id pay_assignment_actions.assignment_id%type
9519: ,c_year_start in DATE
9520: ,c_year_end in DATE)
9521: IS
9522: select /*+ USE_NL(ptp) */ -- Bug 4925650

Line 9526: pay_assignment_Actions paa,

9522: select /*+ USE_NL(ptp) */ -- Bug 4925650
9523: max(paa.assignment_action_id) -- Bug: 3095919, Bug 2610141
9524: from per_assignments_f paf,
9525: pay_payroll_Actions ppa,
9526: pay_assignment_Actions paa,
9527: per_time_periods ptp
9528: where ppa.payroll_Action_id = paa.payroll_Action_id
9529: and paa.assignment_id = c_assignment_id
9530: and paf.assignment_id = c_assignment_id

Line 9550: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;

9546: l_procedure constant varchar2(80) := 'get_lumpsumE_value';
9547: l_retro_lse_ytd number := 0;
9548: v_lump_sum_E_ytd number;
9549: v_lump_sum_E_ptd number;
9550: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;
9551: v_adj_lump_sum_E_ptd number := 0;
9552: v_adj_lump_sum_pre_tax NUMBER := 0; /* Bug 9190980 */
9553: p_result_lsE_ptd_table pay_balance_pkg.t_detailed_bal_out_tab;
9554:

Line 9632: ,p_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE

9628:
9629: /* bug9950136 FW retro adjustmnet */
9630: function adjust_retro_fw
9631: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
9632: ,p_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE
9633: ,p_start_date in date
9634: ,p_end_date in date
9635: ,p_fw_type in varchar2
9636: ,p_retro_fw_gross out nocopy number

Line 9648: ,pay_assignment_actions pac

9644: ppa.effective_date,
9645: pec.classification_name
9646: FROM per_all_assignments_f paa
9647: ,per_periods_of_service pps
9648: ,pay_assignment_actions pac
9649: ,pay_payroll_actions ppa
9650: ,pay_element_entries_f pee
9651: ,pay_run_results prr
9652: ,pay_run_result_values prv