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_PAYROLL_ACTIONS

Line 362: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

358: -- of assignments eligible for archival.
359: --------------------------------------------------------------------+
360:
361: procedure range_code
362: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
363: p_sql out nocopy varchar2) is
364: begin
365: g_debug := hr_utility.debug_enabled;
366: IF g_debug THEN

Line 372: ' pay_payroll_actions pa' ||

368: END if;
369: /* Bug#3043049*/
370: p_sql := ' select distinct p.person_id' ||
371: ' from per_people_f p,' ||
372: ' pay_payroll_actions pa' ||
373: ' where pa.payroll_action_id = :payroll_action_id' ||
374: ' and p.business_group_id = pa.business_group_id' ||
375: ' order by p.person_id';
376: IF g_debug THEN

Line 389: procedure initialization_code (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type) is

385: -- procedure is not present then archiver assumes that no archival is required.
386: --------------------------------------------------------------------+
387:
388:
389: procedure initialization_code (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type) is
390: --
391: --------------------------------------------------------------------------------------+
392: -- Cursor to setup table to hold balance_id's to be retrieved using BBR. (Bug3172963)
393: --------------------------------------------------------------------------------------+

Line 608: FROM pay_payroll_actions ppa

604: IS
605: SELECT to_date('30-06-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),6,4),'DD-MM-YYYY') Financial_year_end
606: ,pay_core_utils.get_parameter('REGISTERED_EMPLOYER',ppa.legislative_parameters) registered_employer /*bug9147430*/
607: ,ppa.business_group_id
608: FROM pay_payroll_actions ppa
609: WHERE ppa.payroll_action_id = c_payroll_Action_id;
610:
611: /* bug 7571001 - added get_balance_attribute cursor to initialize g_attribute_id*/
612: CURSOR get_balance_attribute (c_attribute_name PAY_BAL_ATTRIBUTE_DEFINITIONS.attribute_name%type) IS

Line 1105: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

1101: -- component of more than $1000 for that FBT year
1102: -- and have been terminated during the FBT year
1103:
1104: procedure assignment_action_code
1105: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
1106: p_start_person_id in per_all_people_f.person_id%type,
1107: p_end_person_id in per_all_people_f.person_id%type,
1108: p_chunk in number) is
1109:

Line 1163: from pay_payroll_actions

1159: ,pay_core_utils.get_parameter('LST_YR_TERM',legislative_parameters) lst_yr_term /*3661230*/
1160: ,pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters) Business_group_id
1161: ,decode(pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',legislative_parameters),null,'%',
1162: pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',legislative_parameters)) Assignment_set_id /*Bug 13043341*/
1163: from pay_payroll_actions
1164: where payroll_action_id = c_payroll_Action_id;
1165:
1166: ----------------------------------------------+
1167: -- cursor to restrict assignment ids

Line 1171: Cursor process_assignments(c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

1167: -- cursor to restrict assignment ids
1168: ----------------------------------------------+
1169: /* 4926521 Modified adn put group by in 2 sub queries for performacne */
1170: /* 5099419 Removed fix for bug 4926521 */
1171: Cursor process_assignments(c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
1172: c_start_person_id in per_all_people_f.person_id%type,
1173: c_end_person_id in per_all_people_f.person_id%type)
1174: is
1175: select /*+ INDEX(p per_people_f_pk)

Line 1178: INDEX(pa pay_payroll_actions_pk)

1174: is
1175: select /*+ INDEX(p per_people_f_pk)
1176: INDEX(a per_assignments_f_fk1)
1177: INDEX(a per_assignments_f_N12)
1178: INDEX(pa pay_payroll_actions_pk)
1179: INDEX(pps per_periods_of_service_n3)
1180: */ distinct a.assignment_id
1181: from per_people_f p /*Bug3043049*/
1182: ,per_assignments_f a /*Bug3043049*/

Line 1183: ,pay_payroll_actions pa

1179: INDEX(pps per_periods_of_service_n3)
1180: */ distinct a.assignment_id
1181: from per_people_f p /*Bug3043049*/
1182: ,per_assignments_f a /*Bug3043049*/
1183: ,pay_payroll_actions pa
1184: ,per_periods_of_service pps
1185: where pa.payroll_action_id = c_payroll_action_id
1186: and p.person_id between c_start_person_id and c_end_person_id
1187: and p.person_id = a.person_id

Line 1208: ,pay_payroll_actions rppa

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
1212: and rppa.payroll_action_id = rpac.payroll_action_id

Line 1223: ,pay_payroll_actions rppa

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
1227: + decode(rppa.payroll_id, 0, 0, 0),v_reg_emp,null,null,null,null) > to_number(g_fbt_threshold) /* Bug 5708255 */ --2610141

Line 1241: pay_payroll_actions paas

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'
1245: and paas.report_type ='AU_PAYMENT_SUMMARY_REPORT'

Line 1271: Cursor process_assignments_only(c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

1267:
1268: /* Cursor added for bug3019374 -- Processed when a single assignment is entered*/
1269:
1270:
1271: Cursor process_assignments_only(c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
1272: c_start_person_id in per_all_people_f.person_id%type,
1273: c_end_person_id in per_all_people_f.person_id%type)
1274: is
1275: select distinct a.assignment_id

Line 1278: ,pay_payroll_actions pa

1274: is
1275: select distinct a.assignment_id
1276: from per_people_f p /*Bug3043049*/
1277: ,per_assignments_f a /*Bug3043049*/
1278: ,pay_payroll_actions pa
1279: ,per_periods_of_service pps
1280: where pa.payroll_action_id = c_payroll_action_id
1281: and p.person_id between c_start_person_id and c_end_person_id
1282: and p.person_id = a.person_id

Line 1303: ,pay_payroll_actions rppa

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
1307: and rppa.payroll_action_id = rpac.payroll_action_id

Line 1318: ,pay_payroll_actions rppa

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
1322: + decode(rppa.payroll_id, 0, 0, 0),v_reg_emp,null,null,null,null) > to_number(g_fbt_threshold) /* Bug 5708255 */ --2610141

Line 1336: pay_payroll_actions paas

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'
1340: and paas.report_type ='AU_PAYMENT_SUMMARY_REPORT'

Line 1375: CURSOR range_process_assignments(c_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE,

1371: -- Used when RANGE_PERSON_ID feature is enabled
1372: --------------------------------------------------------------------+
1373: */
1374:
1375: CURSOR range_process_assignments(c_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE,
1376: c_chunk IN NUMBER)
1377: IS
1378: SELECT a.assignment_id
1379: FROM per_people_f p /*Bug3043049*/

Line 1381: ,pay_payroll_actions pa

1377: IS
1378: SELECT a.assignment_id
1379: FROM per_people_f p /*Bug3043049*/
1380: ,per_assignments_f a /*Bug3043049*/
1381: ,pay_payroll_actions pa
1382: ,per_periods_of_service pps
1383: ,pay_population_ranges ppr
1384: WHERE pa.payroll_action_id = c_payroll_action_id
1385: AND pa.payroll_action_id = ppr.payroll_action_id

Line 1411: ,pay_payroll_actions rppa

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
1415: and rppa.payroll_action_id = rpac.payroll_action_id

Line 1426: ,pay_payroll_actions rppa

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
1430: + decode(rppa.payroll_id, 0, 0, 0),v_reg_emp,null,null,null,null) > to_number(g_fbt_threshold) /* Bug 5708255 */ --2610141

Line 1444: pay_payroll_actions paas

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'
1448: AND paas.report_type ='AU_PAYMENT_SUMMARY_REPORT'

Line 1511: CURSOR range_process_assignment_set(c_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE,

1507: -- Used when RANGE_PERSON_ID feature is enabled
1508: --------------------------------------------------------------------------+
1509: */
1510:
1511: CURSOR range_process_assignment_set(c_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE,
1512: c_chunk IN NUMBER)
1513: IS
1514: SELECT a.assignment_id
1515: FROM per_people_f p

Line 1517: ,pay_payroll_actions pa

1513: IS
1514: SELECT a.assignment_id
1515: FROM per_people_f p
1516: ,per_assignments_f a
1517: ,pay_payroll_actions pa
1518: ,per_periods_of_service pps
1519: ,pay_population_ranges ppr
1520: ,hr_assignment_set_amendments hasa
1521: WHERE pa.payroll_action_id = c_payroll_action_id

Line 1550: ,pay_payroll_actions rppa

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
1554: and rppa.payroll_action_id = rpac.payroll_action_id

Line 1565: ,pay_payroll_actions rppa

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
1569: + decode(rppa.payroll_id, 0, 0, 0),v_reg_emp,null,null,null,null) > to_number(g_fbt_threshold)

Line 1583: pay_payroll_actions paas

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'
1587: AND paas.report_type ='AU_PAYMENT_SUMMARY_REPORT'

Line 1607: Cursor process_assignment_set(c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

1603: AND meaning = v_financial_year
1604: );
1605:
1606: /* Bug 13043341 Process assignment set when RANGE_PERSON_ID feature is diabled */
1607: Cursor process_assignment_set(c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
1608: c_start_person_id in per_all_people_f.person_id%type,
1609: c_end_person_id in per_all_people_f.person_id%type)
1610: is
1611: select /*+ INDEX(p per_people_f_pk)

Line 1614: INDEX(pa pay_payroll_actions_pk)

1610: is
1611: select /*+ INDEX(p per_people_f_pk)
1612: INDEX(a per_assignments_f_fk1)
1613: INDEX(a per_assignments_f_N12)
1614: INDEX(pa pay_payroll_actions_pk)
1615: INDEX(pps per_periods_of_service_n3)
1616: */ distinct a.assignment_id
1617: from per_people_f p /*Bug3043049*/
1618: ,per_assignments_f a /*Bug3043049*/

Line 1619: ,pay_payroll_actions pa

1615: INDEX(pps per_periods_of_service_n3)
1616: */ distinct a.assignment_id
1617: from per_people_f p /*Bug3043049*/
1618: ,per_assignments_f a /*Bug3043049*/
1619: ,pay_payroll_actions pa
1620: ,per_periods_of_service pps
1621: ,hr_assignment_set_amendments hasa
1622: where pa.payroll_action_id = c_payroll_action_id
1623: and p.person_id between c_start_person_id and c_end_person_id

Line 1647: ,pay_payroll_actions rppa

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
1651: and rppa.payroll_action_id = rpac.payroll_action_id

Line 1662: ,pay_payroll_actions rppa

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
1666: + decode(rppa.payroll_id, 0, 0, 0),v_reg_emp,null,null,null,null) > to_number(g_fbt_threshold) /* Bug 5708255 */ --2610141

Line 1680: pay_payroll_actions paas

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'
1684: and paas.report_type ='AU_PAYMENT_SUMMARY_REPORT'

Line 2194: ,p_payroll_action_id in pay_payroll_actions.payroll_action_id%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);
2198: v_earnings_ytd varchar2(20);

Line 2719: ,pay_payroll_actions ppa

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
2723: /* below added for bug 7571001 */

Line 3060: pay_payroll_actions ppa,

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
3064: AND paf.assignment_id = c_assignment_id

Line 4447: ,pay_payroll_actions ppa

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'
4451: and piv.name = 'Pay ETP Components'

Line 4475: c_payroll_action_id pay_payroll_actions.payroll_action_id%type,

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')
4479: from pay_action_interlocks pai

Line 4481: ,pay_payroll_actions ppa

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
4485: and pac.assignment_action_id = c_assignment_action_id

Line 4483: ,pay_payroll_actions pppa

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
4487: and ppa.payroll_action_id = c_payroll_action_id

Line 4507: ,pay_payroll_actions ppa

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
4511: and ppa.action_type in ('B','I')

Line 4651: , pay_payroll_actions ppa

4647: from pay_element_types_f pet
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

Line 5107: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

5103: ----------------------------------------------------------------------+
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,

Line 5110: p_year_start in pay_payroll_actions.effective_date%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 */
5114: p_part_prev_etp_flag out nocopy varchar2) is

Line 5111: p_year_end in pay_payroll_Actions.effective_date%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 */
5114: p_part_prev_etp_flag out nocopy varchar2) is
5115:

Line 5112: p_lst_year_start in pay_payroll_Actions.effective_date%type,/Bug3661230 Added one extra parameter/

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 */
5114: p_part_prev_etp_flag out nocopy varchar2) is
5115:
5116:

Line 5143: c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

5139: -----------------------------------------------------------------------------------------------+
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

Line 5145: c_year_start in pay_payroll_actions.effective_date%type,

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
5149: ,pap.last_name employee_last_name

Line 5146: c_year_end in pay_payroll_Actions.effective_date%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
5149: ,pap.last_name employee_last_name
5150: ,pap.first_name employee_first_name

Line 5182: pay_payroll_actions ppa,

5178: per_all_people_f pap,
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

Line 5244: ,pay_payroll_actions ppa

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')
5248: and paa.assignment_id = c_assignment_id

Line 5448: ,p_payroll_action_id in pay_payroll_actions.payroll_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
5452: ,p_year_end in pay_payroll_Actions.effective_date%type

Line 5451: ,p_year_start in pay_payroll_actions.effective_date%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
5452: ,p_year_end in pay_payroll_Actions.effective_date%type
5453: ,p_transitional_flag in varchar2 /*Bug 6192381 Added New Parameters p_transitional_flag and p_part_prev_etp_flag */
5454: ,p_part_prev_etp_flag in varchar2) is
5455:

Line 5452: ,p_year_end in pay_payroll_Actions.effective_date%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
5452: ,p_year_end in pay_payroll_Actions.effective_date%type
5453: ,p_transitional_flag in varchar2 /*Bug 6192381 Added New Parameters p_transitional_flag and p_part_prev_etp_flag */
5454: ,p_part_prev_etp_flag in varchar2) is
5455:
5456:

Line 5985: ,p_payroll_action_id in pay_payroll_actions.payroll_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
5989: ,p_year_end in pay_payroll_Actions.effective_date%type) is

Line 5988: ,p_year_start in pay_payroll_actions.effective_date%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
5989: ,p_year_end in pay_payroll_Actions.effective_date%type) is
5990:
5991: cursor c_get_etp_deduction is
5992: SELECT pet.element_name

Line 5989: ,p_year_end in pay_payroll_Actions.effective_date%type) is

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
5989: ,p_year_end in pay_payroll_Actions.effective_date%type) is
5990:
5991: cursor c_get_etp_deduction is
5992: SELECT pet.element_name
5993: ,to_char(ppa.effective_date,'DDMMYYYY') run_effective_date

Line 5999: ,pay_payroll_actions ppa

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
6003: AND pac.assignment_action_id = prr.assignment_action_id

Line 6022: c_payroll_action_id pay_payroll_actions.payroll_action_id%type) is

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
6026: ,pay_payroll_actions ppa

Line 6026: ,pay_payroll_actions ppa

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
6030: and pac.assignment_action_id = c_assignment_action_id

Line 6028: ,pay_payroll_actions pppa

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
6032: and ppa.payroll_action_id = c_payroll_action_id

Line 6044: ,pay_payroll_actions ppa

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
6048: and paf.assignment_id = p_assignment_id

Line 6958: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

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,
6961: p_year_start in pay_payroll_actions.effective_date%type,
6962: p_year_end in pay_payroll_Actions.effective_date%type) is

Line 6961: p_year_start in pay_payroll_actions.effective_date%type,

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:
6965:

Line 6962: p_year_end in pay_payroll_Actions.effective_date%type) is

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:
6965:
6966: l_group_act_no hr_organization_information.org_information1%type;

Line 7182: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

7178:
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,

Line 7185: p_year_start in pay_payroll_actions.effective_date%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*/
7189:

Line 7186: p_year_end in pay_payroll_Actions.effective_date%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*/
7189:
7190: l_tfn_no pay_element_entry_values_f.screen_entry_value%type;

Line 7188: p_fbt_year_start IN pay_payroll_Actions.effective_date%type) is /Bug# 4653934/

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*/
7189:
7190: l_tfn_no pay_element_entry_values_f.screen_entry_value%type;
7191: l_first_name per_all_people_f.first_name%type;
7192: l_middle_name per_all_people_f.middle_names%type;

Line 7209: l_date_earned pay_payroll_actions.date_earned%type;

7205: l_emp_no per_all_people_f.employee_number%type;
7206: l_payroll pay_all_payrolls_f.payroll_name%type;
7207: l_emp_type per_all_people_f.current_employee_flag%type;
7208: l_address_date_from date;
7209: l_date_earned pay_payroll_actions.date_earned%type;
7210: l_effective_date date; -- Bug3263659
7211: l_actual_termination_date per_periods_of_service.actual_termination_date%type;
7212: l_final_process_date date; -- Bug3263659
7213: l_fpd_archive VARCHAR2(20); -- Bug3098353

Line 7245: c_date_earned pay_payroll_actions.date_earned%TYPE)

7241: /*Bug3019374 - Cursor employee_details broken up into 2 cursor -> cursor employee_details
7242: and cursor tfn_number*/
7243:
7244: cursor tfn_number(c_assignment_id per_all_assignments.assignment_id%TYPE,
7245: c_date_earned pay_payroll_actions.date_earned%TYPE)
7246: is
7247: select pev.screen_entry_value tfn_no
7248: from
7249: pay_element_types_f pet,

Line 7319: pay_payroll_actions ppa,

7315: per_all_people_f pap,
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

Line 7321: pay_payroll_actions ppa1, /* Bug# 2448441 */

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
7325: and ppa.action_type = 'X'

Line 7348: from pay_payroll_actions ppa2,

7344: /* Added for Bug# 2448441 */
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

Line 7724: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

7720: ------------------------------------------------------------------------+
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

Line 7727: p_year_start in pay_payroll_actions.effective_date%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:
7731: l_report_end_date varchar2(20);

Line 7728: p_year_end in pay_payroll_Actions.effective_date%type) is

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:
7731: l_report_end_date varchar2(20);
7732: l_supplier_number hr_organization_information.org_information1%type;

Line 8027: l_business_group_id pay_payroll_actions.business_group_id%type ;

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 ;
8031: l_year_start pay_payroll_Actions.effective_date%type;

Line 8030: l_payroll_action_id pay_payroll_actions.payroll_action_id%type ;

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 ;
8031: l_year_start pay_payroll_Actions.effective_date%type;
8032: l_year_end pay_payroll_actions.effective_date%type;
8033: l_employee_type per_all_people_f.current_Employee_Flag%type;
8034: l_current_employee_flag per_all_people_f.current_employee_flag%type :='Y';

Line 8031: l_year_start pay_payroll_Actions.effective_date%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 ;
8031: l_year_start pay_payroll_Actions.effective_date%type;
8032: l_year_end pay_payroll_actions.effective_date%type;
8033: l_employee_type per_all_people_f.current_Employee_Flag%type;
8034: l_current_employee_flag per_all_people_f.current_employee_flag%type :='Y';
8035: l_actual_termination_date per_periods_of_service.actual_termination_date%TYPE;

Line 8032: l_year_end pay_payroll_actions.effective_date%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 ;
8031: l_year_start pay_payroll_Actions.effective_date%type;
8032: l_year_end pay_payroll_actions.effective_date%type;
8033: l_employee_type per_all_people_f.current_Employee_Flag%type;
8034: l_current_employee_flag per_all_people_f.current_employee_flag%type :='Y';
8035: l_actual_termination_date per_periods_of_service.actual_termination_date%TYPE;
8036: l_date_start per_periods_of_service.date_start%TYPE;

Line 8037: l_asg_start pay_payroll_actions.effective_date%type;

8033: l_employee_type per_all_people_f.current_Employee_Flag%type;
8034: l_current_employee_flag per_all_people_f.current_employee_flag%type :='Y';
8035: l_actual_termination_date per_periods_of_service.actual_termination_date%TYPE;
8036: l_date_start per_periods_of_service.date_start%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;

Line 8038: l_asg_end pay_payroll_actions.effective_date%type;

8034: l_current_employee_flag per_all_people_f.current_employee_flag%type :='Y';
8035: l_actual_termination_date per_periods_of_service.actual_termination_date%TYPE;
8036: l_date_start per_periods_of_service.date_start%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;

Line 8039: l_effective_date pay_payroll_actions.effective_date%type;

8035: l_actual_termination_date per_periods_of_service.actual_termination_date%TYPE;
8036: l_date_start per_periods_of_service.date_start%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;

Line 8080: , pay_payroll_actions ppa

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: --
8084: -------------------------------------------------+

Line 8091: ,c_lst_year_start in pay_payroll_actions.effective_date%type --3263659

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
8095: ,c_business_group_id in pay_payroll_actions.business_group_id%type

Line 8092: ,c_year_start in pay_payroll_actions.effective_date%type

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
8095: ,c_business_group_id in pay_payroll_actions.business_group_id%type
8096: ) is

Line 8093: ,c_year_end in pay_payroll_actions.effective_date%type

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
8095: ,c_business_group_id in pay_payroll_actions.business_group_id%type
8096: ) is
8097: select distinct nvl(current_employee_flag,'N') current_employee_flag,

Line 8095: ,c_business_group_id in pay_payroll_actions.business_group_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
8095: ,c_business_group_id in pay_payroll_actions.business_group_id%type
8096: ) is
8097: select distinct nvl(current_employee_flag,'N') current_employee_flag,
8098: actual_termination_date,
8099: date_start,

Line 8107: pay_payroll_actions pa,

8103: from per_all_people_f p,
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

Line 8153: from pay_payroll_actions ppa,

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
8156: and ppa.payroll_action_id = paa.payroll_action_id;
8157: --

Line 8190: pay_payroll_actions ppa,

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
8194: and paa.assignment_id = c_assignment_id

Line 8216: ,c_year_start pay_payroll_actions.effective_date%type

8212: */
8213: cursor csr_check_eff_le
8214: (c_assignment_id per_assignments_f.assignment_id%type
8215: ,c_legal_employer hr_organization_units.organization_id%type
8216: ,c_year_start pay_payroll_actions.effective_date%type
8217: ,c_year_end pay_payroll_actions.effective_date%type
8218: ) is
8219: select paaf.assignment_id
8220: from per_assignments_f paaf,

Line 8217: ,c_year_end pay_payroll_actions.effective_date%type

8213: cursor csr_check_eff_le
8214: (c_assignment_id per_assignments_f.assignment_id%type
8215: ,c_legal_employer hr_organization_units.organization_id%type
8216: ,c_year_start pay_payroll_actions.effective_date%type
8217: ,c_year_end pay_payroll_actions.effective_date%type
8218: ) is
8219: select paaf.assignment_id
8220: from per_assignments_f paaf,
8221: hr_soft_coding_keyflex hsck

Line 8232: ,c_year_start pay_payroll_actions.effective_date%type

8228:
8229: /* Bug 5371102 - Added joins on Payroll ID for better performance */
8230: cursor csr_get_dates
8231: (c_assignment_id per_assignments_f.assignment_id%type
8232: ,c_year_start pay_payroll_actions.effective_date%type
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')

Line 8233: ,c_year_end pay_payroll_actions.effective_date%type

8229: /* Bug 5371102 - Added joins on Payroll ID for better performance */
8230: cursor csr_get_dates
8231: (c_assignment_id per_assignments_f.assignment_id%type
8232: ,c_year_start pay_payroll_actions.effective_date%type
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,

Line 8238: pay_payroll_actions ppa,

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
8242: and paa.payroll_action_id = ppa.payroll_action_id

Line 8255: ,c_year_end pay_payroll_actions.effective_date%type

8251: -- assignment between FBT year start and financial year end.
8252: --
8253: cursor csr_get_end_le
8254: (c_assignment_id per_assignments_f.assignment_id%type
8255: ,c_year_end pay_payroll_actions.effective_date%type
8256: ,c_year_start pay_payroll_actions.effective_date%type
8257: ) is
8258: select hsck.segment1
8259: from per_assignments_f paaf,

Line 8256: ,c_year_start pay_payroll_actions.effective_date%type

8252: --
8253: cursor csr_get_end_le
8254: (c_assignment_id per_assignments_f.assignment_id%type
8255: ,c_year_end pay_payroll_actions.effective_date%type
8256: ,c_year_start pay_payroll_actions.effective_date%type
8257: ) is
8258: select hsck.segment1
8259: from per_assignments_f paaf,
8260: hr_soft_coding_keyflex hsck

Line 8277: pay_payroll_actions ppa,

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
8281: WHERE paa.assignment_id = paf.assignment_id

Line 9395: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type)

9391: -- Following Procedure is created as per enhancement - Bug#3132178
9392: -- This procedure checks if TEST_EFILE flag is TRUE then submit a request for Magtape Process
9393:
9394: procedure spawn_data_file
9395: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type)
9396: is
9397:
9398: ps_request_id NUMBER;
9399: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;

Line 9399: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;

9395: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type)
9396: is
9397:
9398: ps_request_id NUMBER;
9399: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
9400: l_business_group_id number;
9401: l_start_date date;
9402: l_end_date date;
9403: l_effective_date date;

Line 9416: CURSOR csr_magtape_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)

9412: -- Description : Fetches User Parameters from Legislative_paramters
9413: -- column.
9414: --------------------------------------------------------------------+
9415:
9416: CURSOR csr_magtape_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
9417: IS
9418: SELECT pay_core_utils.get_parameter('TEST_EFILE',legislative_parameters) TEST_EFILE,
9419: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters) BUSINESS_GROUP_ID,
9420: pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters) FINANCIAL_YEAR,

Line 9425: FROM pay_payroll_actions ppa

9421: pay_core_utils.get_parameter('REGISTERED_EMPLOYER',legislative_parameters) REGISTERED_EMPLOYER,
9422: to_date(pay_core_utils.get_parameter('START_DATE',legislative_parameters),'YYYY/MM/DD') start_date,
9423: to_date(pay_core_utils.get_parameter('END_DATE',legislative_parameters),'YYYY/MM/DD') end_date,
9424: to_date(pay_core_utils.get_parameter('EFFECTIVE_DATE',legislative_parameters),'YYYY/MM/DD') EFFECTIVE_DATE
9425: FROM pay_payroll_actions ppa
9426: WHERE ppa.payroll_action_id = c_payroll_action_id;
9427:
9428:
9429: CURSOR csr_lookup_code (c_financial_year varchar2)

Line 9525: pay_payroll_Actions ppa,

9521: IS
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

Line 9649: ,pay_payroll_actions ppa

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
9653: ,pay_element_types_f pet