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 341: FUNCTION get_earnings(p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)

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

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

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

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

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

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

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

Line 420: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;

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

Line 433: , pay_assignment_actions paa

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

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

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

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

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

Line 585: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;

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

Line 599: ,pay_assignment_actions paa

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

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

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

Line 685: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;

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

Line 697: , pay_assignment_actions paa

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

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

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

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

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

Line 783: ,pay_assignment_actions paa

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

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

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

Line 808: , pay_assignment_actions paa

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

Line 825: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;

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

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

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

Line 920: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;

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

Line 941: FROM pay_assignment_actions paa

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