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_HK_SOE_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

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

85: -- Procedure to merely pass all the balance results back in one hit,
86: -- rather than separate calls for each balance.
87: ------------------------------------------------------------------------
88: procedure balance_totals
89: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
90: p_tax_unit_id in pay_assignment_actions.tax_unit_id%type,
91: p_total_earnings_this_pay out nocopy number,
92: p_total_earnings_ytd out nocopy number,
93: p_total_deductions_this_pay out nocopy number,

Line 90: p_tax_unit_id in pay_assignment_actions.tax_unit_id%type,

86: -- rather than separate calls for each balance.
87: ------------------------------------------------------------------------
88: procedure balance_totals
89: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
90: p_tax_unit_id in pay_assignment_actions.tax_unit_id%type,
91: p_total_earnings_this_pay out nocopy number,
92: p_total_earnings_ytd out nocopy number,
93: p_total_deductions_this_pay out nocopy number,
94: p_total_deductions_ytd out nocopy number,

Line 285: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;

281: FUNCTION getelements(p_assignment_action_id IN NUMBER
282: ,p_classification_name IN VARCHAR2
283: ) RETURN LONG
284: IS
285: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;
286:
287: CURSOR csr_locked_action_id
288: IS
289: SELECT max(locked_action_id)

Line 340: FUNCTION get_earnings(p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)

336: -- Parameters : --
337: -- IN : p_assignment_action_id NUMBER --
338: -- Bug 5396046 --
339: --------------------------------------------------------------------------
340: FUNCTION get_earnings(p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
341: RETURN LONG
342: IS
343:
344: BEGIN

Line 364: FUNCTION get_deductions(p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)

360: -- Parameters : --
361: -- IN : p_assignment_action_id NUMBER --
362: -- Bug 5396046 --
363: --------------------------------------------------------------------------
364: FUNCTION get_deductions(p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
365: RETURN LONG
366: IS
367:
368: BEGIN

Line 389: FUNCTION get_employer_liabilities(p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)

385: -- Parameters : --
386: -- IN : p_assignment_action_id NUMBER --
387: -- Bug 5396046 --
388: --------------------------------------------------------------------------
389: FUNCTION get_employer_liabilities(p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
390: RETURN LONG
391: IS
392:
393: BEGIN

Line 413: FUNCTION get_balances( p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE)

409: -- Parameters : --
410: -- IN : p_assignment_action_id NUMBER --
411: -- Bug 5396046 --
412: --------------------------------------------------------------------------
413: FUNCTION get_balances( p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE)
414: RETURN LONG
415: IS
416:
417: l_date_earned DATE;

Line 419: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;

415: IS
416:
417: l_date_earned DATE;
418: l_tax_unit_id NUMBER;
419: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;
420: l_dimension pay_balance_dimensions.dimension_name%type;
421:
422: CURSOR csr_locked_action_id
423: IS

Line 432: , pay_assignment_actions paa

428: CURSOR csr_get_date_earned
429: IS
430: SELECT ppa.date_earned, paa.tax_unit_id
431: FROM pay_payroll_actions ppa
432: , pay_assignment_actions paa
433: WHERE ppa.payroll_action_id = paa.payroll_action_id
434: AND paa.assignment_action_id = p_assignment_action_id;
435:
436: BEGIN

Line 524: FUNCTION get_payment_methods(p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE)

520: -- Parameters : --
521: -- IN : p_assignment_action_id NUMBER --
522: -- Bug 5396046 --
523: --------------------------------------------------------------------------
524: FUNCTION get_payment_methods(p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE)
525: RETURN LONG
526: IS
527: BEGIN
528:

Line 580: FUNCTION get_other_element_information(p_assignment_action_id IN OUT NOCOPY pay_assignment_actions.assignment_action_id%TYPE)

576: -- Parameters : --
577: -- IN : p_assignment_action_id NUMBER --
578: -- Bug 5396046 --
579: --------------------------------------------------------------------------
580: FUNCTION get_other_element_information(p_assignment_action_id IN OUT NOCOPY pay_assignment_actions.assignment_action_id%TYPE)
581: RETURN LONG
582: IS
583:
584: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;

Line 584: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;

580: FUNCTION get_other_element_information(p_assignment_action_id IN OUT NOCOPY pay_assignment_actions.assignment_action_id%TYPE)
581: RETURN LONG
582: IS
583:
584: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
585: l_business_group_id per_business_groups.business_group_id%TYPE;
586: l_effective_date pay_payroll_actions.effective_date%TYPE;
587:
588: CURSOR csr_prepayment

Line 598: ,pay_assignment_actions paa

594: CURSOR csr_get_bg_id
595: IS
596: SELECT ppa.business_group_id,ppa.effective_date
597: FROM pay_payroll_actions ppa
598: ,pay_assignment_actions paa
599: WHERE ppa.payroll_action_id = paa.payroll_action_id
600: AND paa.assignment_action_id = p_assignment_action_id;
601:
602: BEGIN

Line 677: FUNCTION get_other_balance_information(p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)

673: -- Parameters : --
674: -- IN : p_assignment_action_id NUMBER --
675: -- Bug 5396046 --
676: --------------------------------------------------------------------------
677: FUNCTION get_other_balance_information(p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
678: RETURN LONG
679: IS
680:
681: l_date_earned DATE;

Line 684: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;

680:
681: l_date_earned DATE;
682: l_tax_unit_id NUMBER;
683: l_business_group_id per_business_groups.business_group_id%TYPE;
684: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;
685:
686: CURSOR csr_locked_action_id
687: IS
688: SELECT max(locked_action_id)

Line 696: , pay_assignment_actions paa

692: CURSOR csr_get_date_earned
693: IS
694: SELECT ppa.date_earned, ppa.business_group_id, paa.tax_unit_id
695: FROM pay_payroll_actions ppa
696: , pay_assignment_actions paa
697: WHERE ppa.payroll_action_id = paa.payroll_action_id
698: AND paa.assignment_action_id = p_assignment_action_id;
699:
700: BEGIN

Line 765: FUNCTION get_annual_leave_info(p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)

761: -- Parameters : --
762: -- IN : p_assignment_action_id NUMBER --
763: -- Bug 5396046 --
764: --------------------------------------------------------------------------
765: FUNCTION get_annual_leave_info(p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
766: RETURN LONG
767: IS
768:
769: CURSOR csr_get_annual_leave_details(p_payroll_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)

Line 769: CURSOR csr_get_annual_leave_details(p_payroll_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)

765: FUNCTION get_annual_leave_info(p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
766: RETURN LONG
767: IS
768:
769: CURSOR csr_get_annual_leave_details(p_payroll_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
770: IS
771: SELECT pap.accrual_plan_name
772: ,hr_general_utilities.get_lookup_meaning('US_PTO_ACCRUAL',pap.accrual_category)
773: ,hr_general.decode_lookup('HOURS_OR_DAYS',pap.accrual_units_of_measure)

Line 782: ,pay_assignment_actions paa

778: FROM pay_accrual_plans pap
779: ,pay_element_types_f pet
780: ,pay_element_links_f pel
781: ,pay_element_entries_f pee
782: ,pay_assignment_actions paa
783: ,pay_payroll_actions ppa
784: WHERE pet.element_type_id = pap.accrual_plan_element_type_id
785: AND pel.element_type_id = pet.element_type_id
786: AND pee.element_link_id = pel.element_link_id

Line 803: CURSOR csr_get_date_earned(c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)

799:
800: /*Bug 6074090 Added parameter c_assignment_action_id as date earned is not populated for pre payment action id,
801: Date earned of Payroll needs to be fetched */
802:
803: CURSOR csr_get_date_earned(c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
804: IS
805: SELECT ppa.date_earned
806: FROM pay_payroll_actions ppa
807: , pay_assignment_actions paa

Line 807: , pay_assignment_actions paa

803: CURSOR csr_get_date_earned(c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
804: IS
805: SELECT ppa.date_earned
806: FROM pay_payroll_actions ppa
807: , pay_assignment_actions paa
808: WHERE ppa.payroll_action_id = paa.payroll_action_id
809: AND paa.assignment_action_id = c_assignment_action_id;
810:
811: CURSOR csr_prepayment

Line 824: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;

820: l_payroll_id pay_payrolls_f.payroll_id%TYPE;
821: l_business_group_id per_business_groups.business_group_id%TYPE;
822: l_accrual_plan_id pay_accrual_plans.accrual_plan_id%TYPE;
823: l_assignment_id per_assignments_f.assignment_id%TYPE;
824: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
825: l_annual_leave_balance NUMBER;
826: l_ovn NUMBER;
827: l_leave_taken NUMBER;
828: l_start_date DATE;

Line 911: FUNCTION get_leave_taken(p_assignment_action_id IN OUT NOCOPY pay_assignment_actions.assignment_action_id%TYPE)

907: -- Parameters : --
908: -- IN : p_assignment_action_id NUMBER --
909: -- Bug 5396046 --
910: --------------------------------------------------------------------------
911: FUNCTION get_leave_taken(p_assignment_action_id IN OUT NOCOPY pay_assignment_actions.assignment_action_id%TYPE)
912: RETURN LONG
913: IS
914:
915: CURSOR csr_prepayment

Line 921: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;

917: SELECT MAX(locked_action_id)
918: FROM pay_action_interlocks
919: WHERE locking_action_id = p_assignment_action_id;
920:
921: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
922:
923: BEGIN
924:
925:

Line 942: FROM pay_assignment_actions paa

938: ,TO_CHAR(decode(pet.processing_type,''R'',greatest(pab.date_start,PTP.START_DATE),pab.date_start),''DD-Mon-YYYY'') COL02
939: ,TO_CHAR(decode(pet.processing_type,''R'',least(pab.date_end,PTP.END_DATE),pab.date_end),''DD-Mon-YYYY'') COL03
940: ,hr_general.decode_lookup(''HOURS_OR_DAYS'',pat.HOURS_OR_DAYS) COL04
941: ,TO_CHAR(decode(pet.processing_type,''R'',to_number(prrv.result_value),nvl(pab.absence_days,pab.absence_hours))) COL16
942: FROM pay_assignment_actions paa
943: ,pay_payroll_actions ppa
944: ,pay_run_results prr
945: ,pay_run_result_values prrv
946: ,per_time_periods ptp