[Home] [Help]
565: rppa.payroll_id,
566: nvl(rppa.pay_advice_date,ptp.pay_advice_date),
567: rppa.pay_advice_message
568: from pay_assignment_actions paa,
569: pay_payroll_actions ppa,
570: pay_assignment_actions rpaa,
571: per_time_periods ptp,
572: pay_payroll_actions rppa
573: where paa.payroll_action_id = ppa.payroll_action_id
568: from pay_assignment_actions paa,
569: pay_payroll_actions ppa,
570: pay_assignment_actions rpaa,
571: per_time_periods ptp,
572: pay_payroll_actions rppa
573: where paa.payroll_action_id = ppa.payroll_action_id
574: and rppa.payroll_action_id = rpaa.payroll_action_id
575: and rppa.time_period_id = ptp.time_period_id
576: and paa.assignment_action_id =
574: and rppa.payroll_action_id = rpaa.payroll_action_id
575: and rppa.time_period_id = ptp.time_period_id
576: and paa.assignment_action_id =
577: (select to_number(substr(max(to_char(pa.effective_date,'J')||lpad(aa.assignment_action_id,15,'0')),8))
578: from pay_payroll_actions pa,
579: pay_assignment_actions aa
580: where pa.action_type in ('U','P') /* Bug No : 2674887 */
581: and aa.action_status = 'C'
582: and pa.payroll_action_id = aa.payroll_action_id
626: cursor get_action_type is
627: -- find type of action this is
628: select pact.action_type , assact.assignment_id
629: from pay_assignment_actions assact,
630: pay_payroll_actions pact
631: where assact.assignment_action_id = p_assignment_action_id
632: and pact.payroll_action_id =
633: assact.payroll_action_id
634: ;
644: cursor get_prepay is
645: -- for run action check if its been prepaid
646: select assact.assignment_action_id
647: from pay_assignment_actions assact,
648: pay_payroll_actions pact,
649: pay_action_interlocks loc
650: where loc.locked_action_id = p_assignment_action_id
651: and assact.assignment_action_id = loc.locking_action_id
652: and pact.payroll_action_id = assact.payroll_action_id
664: ptp.period_name,
665: nvl(pact.pay_advice_date,ptp.pay_advice_date),
666: pay_advice_message
667: from pay_assignment_actions assact,
668: pay_payroll_actions pact,
669: per_time_periods ptp
670: where assact.assignment_action_id = p_run_assignment_action_id
671: and pact.payroll_action_id = assact.payroll_action_id
672: and pact.payroll_id = ptp.payroll_id
672: and pact.payroll_id = ptp.payroll_id
673: and pact.date_earned between ptp.start_date and ptp.end_date ;
674: --
675: -- Bug-2595888: Changed the variable type from varchar2(1)
676: l_action_type pay_payroll_actions.action_type%type;
677: --
678: begin
679: --
680: open get_action_type;
859:
860: function super_fund_name
861: (p_source_id in number,
862: p_element_reporting_name in pay_element_types_f.reporting_name%type,
863: p_date_earned in pay_payroll_actions.date_earned%type,
864: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
865: p_assignment_id in per_all_assignments_f.assignment_id%type,
866: p_element_entry_id in pay_element_entries_f.PERSONAL_PAYMENT_METHOD_ID%TYPE,
867: p_business_group_id per_all_assignments_f.business_group_id%TYPE)
1129: p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE,
1130: p_element_type_id IN pay_element_entries_f.element_entry_id%TYPE,
1131: p_pay_bases_id IN per_all_assignments_f.pay_basis_id%TYPE,
1132: p_run_result_id IN pay_run_results.run_result_ID%TYPE,
1133: p_effective_date IN pay_payroll_actions.effective_date%TYPE
1134: )
1135: RETURN NUMBER
1136: IS
1137:
1243: (
1244: p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE,
1245: p_element_type_id IN pay_element_entries_f.element_entry_id%TYPE,
1246: p_run_result_id IN pay_run_results.run_result_ID%TYPE,
1247: p_effective_date IN pay_payroll_actions.effective_date%TYPE
1248: )
1249: RETURN NUMBER
1250: IS
1251:
1324: FUNCTION get_leave_taken_hours
1325: (
1326: p_element_type_id IN pay_element_entries_f.element_entry_id%TYPE,
1327: p_run_result_id IN pay_run_results.run_result_ID%TYPE,
1328: p_effective_date IN pay_payroll_actions.effective_date%TYPE
1329: )
1330: RETURN NUMBER
1331: IS
1332:
1433: c_get_prepay_eff_date - Cursor fetches effective date of pre-payments */
1434:
1435: FUNCTION get_effective_date
1436: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%TYPE)
1437: RETURN pay_payroll_actions.effective_date%TYPE
1438: IS
1439:
1440: CURSOR c_get_payments_eff_date(c_assignment_action_id in pay_assignment_actions.assignment_action_id%TYPE)
1441: IS
1439:
1440: CURSOR c_get_payments_eff_date(c_assignment_action_id in pay_assignment_actions.assignment_action_id%TYPE)
1441: IS
1442: SELECT max(ppa.effective_date)
1443: FROM pay_payroll_actions ppa ,
1444: pay_assignment_actions paa ,
1445: pay_action_interlocks pai
1446: WHERE pai.locked_action_id = c_assignment_action_id
1447: AND pai.locking_action_id = paa.assignment_action_id
1451:
1452: CURSOR c_get_prepay_eff_date(c_assignment_action_id in pay_assignment_actions.assignment_action_id%TYPE)
1453: is
1454: SELECT ppa.effective_date
1455: FROM pay_payroll_actions ppa ,
1456: pay_assignment_actions paa
1457: WHERE paa.assignment_action_id = c_assignment_action_id
1458: AND ppa.payroll_action_id = paa.payroll_action_id;
1459:
1456: pay_assignment_actions paa
1457: WHERE paa.assignment_action_id = c_assignment_action_id
1458: AND ppa.payroll_action_id = paa.payroll_action_id;
1459:
1460: l_effective_date pay_payroll_actions.effective_date%TYPE;
1461:
1462: BEGIN
1463:
1464: OPEN c_get_payments_eff_date(p_assignment_action_id);
1497: return varchar2 is
1498:
1499: cursor get_assign_info (p_assignment_id number, p_payroll_action_id number) is
1500: select paf.person_id, paf.location_id, paf.organization_id, paf.business_group_id
1501: from per_all_assignments_f paf, pay_payroll_actions ppa
1502: where paf.assignment_id = p_assignment_id
1503: and ppa.payroll_action_id = p_payroll_action_id
1504: and (ppa.effective_date between paf.effective_start_date and paf.effective_end_date);
1505: