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

Line 20: FUNCTION get_employee(p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE)

16: -- Parameters : --
17: -- IN : p_assignment_action_id NUMBER --
18: -- --
19: --------------------------------------------------------------------------
20: FUNCTION get_employee(p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE)
21: RETURN LONG
22: IS
23: l_procedure VARCHAR2(50);
24: l_reg_legal_name VARCHAR2(150);

Line 34: , pay_assignment_actions paa

30: ,hr_soft_coding_keyflex hrscf
31: ,hr_organization_information hoi
32: ,hr_organization_units hou
33: ,hr_organization_information hoi2
34: , pay_assignment_actions paa
35: , pay_payroll_actions ppa
36: WHERE
37: paa.assignment_action_id = p_assignment_action_id
38: AND paa.payroll_action_id = ppa.payroll_action_id

Line 140: FUNCTION get_fur_person_info(p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE)

136: -- Parameters : --
137: -- IN : p_assignment_action_id NUMBER --
138: -- --
139: --------------------------------------------------------------------------
140: FUNCTION get_fur_person_info(p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE)
141: RETURN LONG
142: IS
143: l_procedure VARCHAR2(50);
144:

Line 186: FUNCTION get_period(p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE)

182: -- Parameters : --
183: -- IN : p_assignment_action_id NUMBER --
184: -- --
185: --------------------------------------------------------------------------
186: FUNCTION get_period(p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE)
187: RETURN LONG
188: IS
189: l_procedure VARCHAR2(50);
190: l_action_type VARCHAR2(2);

Line 196: ,pay_assignment_actions aa

192: CURSOR periodDates IS
193: SELECT action_type FROM
194: pay_payroll_actions pa
195: ,per_time_periods tp
196: ,pay_assignment_actions aa
197: WHERE pa.payroll_action_id = aa.payroll_action_id
198: AND pa.effective_date = tp.regular_payment_date
199: AND pa.payroll_id = tp.payroll_id
200: AND aa.assignment_action_id = p_assignment_action_id;

Line 225: ,pay_assignment_actions aa1

221: from pay_payroll_actions pa1
222: ,pay_payroll_actions pa2
223: ,per_time_periods tp1
224: ,per_time_periods tp2
225: ,pay_assignment_actions aa1
226: ,pay_assignment_actions aa2
227: where pa1.payroll_action_id = aa1.payroll_action_id
228: and pa1.effective_date = tp1.regular_payment_date
229: and pa1.payroll_id = tp1.payroll_id

Line 226: ,pay_assignment_actions aa2

222: ,pay_payroll_actions pa2
223: ,per_time_periods tp1
224: ,per_time_periods tp2
225: ,pay_assignment_actions aa1
226: ,pay_assignment_actions aa2
227: where pa1.payroll_action_id = aa1.payroll_action_id
228: and pa1.effective_date = tp1.regular_payment_date
229: and pa1.payroll_id = tp1.payroll_id
230: and aa1.assignment_action_id = :PREPAY_MIN_ACTION

Line 246: ,pay_assignment_actions aa

242: ,fnd_date.date_to_displaydate(tp.start_date) COL02
243: ,tp.period_type COL07
244: from pay_payroll_actions pa
245: ,per_time_periods tp
246: ,pay_assignment_actions aa
247: where pa.payroll_action_id = aa.payroll_action_id
248: and pa.effective_date = tp.regular_payment_date
249: and pa.payroll_id = tp.payroll_id
250: and aa.assignment_action_id = :assignment_action_id';

Line 263: ,pay_assignment_actions aa

259: ,fnd_date.date_to_displaydate(tp.start_date) COL02
260: ,tp.period_type COL07
261: from pay_payroll_actions pa
262: ,per_time_periods tp
263: ,pay_assignment_actions aa
264: where pa.payroll_action_id = aa.payroll_action_id
265: and pa.time_period_id = tp.time_period_id
266: and aa.assignment_action_id = :assignment_action_id';
267: end if;

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

335: -- Parameters : --
336: -- IN : p_assignment_action_id NUMBER --
337: -- --
338: --------------------------------------------------------------------------
339: FUNCTION get_earnings(p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
340: RETURN LONG
341: IS
342: l_procedure VARCHAR2(50);
343:

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

364: -- Parameters : --
365: -- IN : p_assignment_action_id NUMBER --
366: -- --
367: --------------------------------------------------------------------------
368: FUNCTION get_deductions(p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
369: RETURN LONG
370: IS
371: l_procedure VARCHAR2(50);
372:

Line 398: FUNCTION get_advances(p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)

394: -- Parameters : --
395: -- IN : p_assignment_action_id NUMBER --
396: -- --
397: --------------------------------------------------------------------------
398: FUNCTION get_advances(p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
399: RETURN LONG
400: IS
401: l_procedure VARCHAR2(50);
402: BEGIN

Line 426: FUNCTION get_fringe_benefits(p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)

422: -- Parameters : --
423: -- IN : p_assignment_action_id NUMBER --
424: -- --
425: --------------------------------------------------------------------------
426: FUNCTION get_fringe_benefits(p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
427: RETURN LONG
428: IS
429: l_procedure VARCHAR2(50);
430: BEGIN

Line 455: FUNCTION get_perquisites(p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)

451: -- Parameters : --
452: -- IN : p_assignment_action_id NUMBER --
453: -- --
454: --------------------------------------------------------------------------
455: FUNCTION get_perquisites(p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
456: RETURN LONG
457: IS
458: l_procedure VARCHAR2(50);
459: BEGIN

Line 484: FUNCTION get_employer_charges(p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)

480: -- Parameters : --
481: -- IN : p_assignment_action_id NUMBER --
482: -- --
483: --------------------------------------------------------------------------
484: FUNCTION get_employer_charges(p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
485: RETURN LONG
486: IS
487: l_procedure VARCHAR2(50);
488: BEGIN

Line 513: FUNCTION get_term_payments(p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)

509: -- Parameters : --
510: -- IN : p_assignment_action_id NUMBER --
511: -- --
512: --------------------------------------------------------------------------
513: FUNCTION get_term_payments(p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
514: RETURN LONG
515: IS
516: l_procedure VARCHAR2(50);
517: BEGIN

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

537: -- Parameters : --
538: -- IN : p_assignment_action_id NUMBER --
539: -- --
540: --------------------------------------------------------------------------
541: FUNCTION get_balances( p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE)
542: RETURN LONG
543: IS
544:
545: CURSOR csr_get_tax_till_date

Line 633: FUNCTION get_payment_details(p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE)

629: -- Parameters : --
630: -- IN : p_assignment_action_id NUMBER --
631: -- --
632: --------------------------------------------------------------------------
633: FUNCTION get_payment_details(p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE)
634: RETURN LONG
635: IS
636:
637: l_procedure VARCHAR2(50);

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

697: -- Parameters : --
698: -- IN : p_assignment_action_id NUMBER --
699: -- --
700: --------------------------------------------------------------------------
701: FUNCTION get_other_element_information(p_assignment_action_id IN OUT NOCOPY pay_assignment_actions.assignment_action_id%TYPE)
702: RETURN LONG
703: IS
704:
705: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;

Line 705: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;

701: FUNCTION get_other_element_information(p_assignment_action_id IN OUT NOCOPY pay_assignment_actions.assignment_action_id%TYPE)
702: RETURN LONG
703: IS
704:
705: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
706: l_business_group_id per_business_groups.business_group_id%TYPE;
707: l_procedure VARCHAR2(100);
708:
709: CURSOR csr_prepayment

Line 719: ,pay_assignment_actions paa

715: CURSOR csr_get_bg_id
716: IS
717: SELECT ppa.business_group_id
718: FROM pay_payroll_actions ppa
719: ,pay_assignment_actions paa
720: WHERE ppa.payroll_action_id = paa.payroll_action_id
721: AND paa.assignment_action_id = p_assignment_action_id;
722:
723:

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

772: -- Parameters : --
773: -- IN : p_assignment_action_id NUMBER --
774: -- --
775: --------------------------------------------------------------------------
776: FUNCTION get_other_balance_information(p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
777: RETURN LONG
778: IS
779:
780: l_date_earned DATE;

Line 789: , pay_assignment_actions paa

785: CURSOR csr_get_date_earned
786: IS
787: SELECT ppa.date_earned, ppa.business_group_id
788: FROM pay_payroll_actions ppa
789: , pay_assignment_actions paa
790: WHERE ppa.payroll_action_id = paa.payroll_action_id
791: AND paa.assignment_action_id = p_assignment_action_id;
792:
793: CURSOR csr_get_tax_unit_id

Line 798: , pay_assignment_actions paa

794: IS
795: SELECT hsck.segment1
796: FROM hr_soft_coding_keyflex hsck
797: , per_assignments_f paf
798: , pay_assignment_actions paa
799: , pay_payroll_actions ppa
800: WHERE hsck.soft_coding_keyflex_id = paf.soft_coding_keyflex_id
801: AND paa.assignment_action_id = p_assignment_action_id
802: AND paa.payroll_action_id = ppa.payroll_action_id

Line 853: FUNCTION get_annual_leave_information(p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)

849: -- Parameters : --
850: -- IN : p_assignment_action_id NUMBER --
851: -- --
852: --------------------------------------------------------------------------
853: FUNCTION get_annual_leave_information(p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
854: RETURN LONG
855: IS
856:
857: CURSOR csr_get_annual_leave_details(p_payroll_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)

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

853: FUNCTION get_annual_leave_information(p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
854: RETURN LONG
855: IS
856:
857: CURSOR csr_get_annual_leave_details(p_payroll_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
858: IS
859: SELECT pap.accrual_plan_name
860: ,hr_general_utilities.get_lookup_meaning('US_PTO_ACCRUAL',pap.accrual_category)
861: ,hr_general.decode_lookup('HOURS_OR_DAYS',pap.accrual_units_of_measure)

Line 870: ,pay_assignment_actions paa

866: FROM pay_accrual_plans pap
867: ,pay_element_types_f pet
868: ,pay_element_links_f pel
869: ,pay_element_entries_f pee
870: ,pay_assignment_actions paa
871: ,pay_payroll_actions ppa
872: WHERE pet.element_type_id = pap.accrual_plan_element_type_id
873: AND pel.element_type_id = pet.element_type_id
874: AND pee.element_link_id = pel.element_link_id

Line 891: , pay_assignment_actions paa

887: CURSOR csr_get_date_earned
888: IS
889: SELECT ppa.date_earned
890: FROM pay_payroll_actions ppa
891: , pay_assignment_actions paa
892: WHERE ppa.payroll_action_id = paa.payroll_action_id
893: AND paa.assignment_action_id = p_assignment_action_id;
894:
895: CURSOR csr_prepayment

Line 908: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;

904: l_payroll_id pay_payrolls_f.payroll_id%TYPE;
905: l_business_group_id per_business_groups.business_group_id%TYPE;
906: l_accrual_plan_id pay_accrual_plans.accrual_plan_id%TYPE;
907: l_assignment_id per_assignments_f.assignment_id%TYPE;
908: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
909: l_annual_leave_balance NUMBER;
910: l_ovn NUMBER;
911: l_leave_taken NUMBER;
912: l_start_date DATE;

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

1006: -- Parameters : --
1007: -- IN : p_assignment_action_id NUMBER --
1008: -- --
1009: --------------------------------------------------------------------------
1010: FUNCTION get_leave_taken(p_assignment_action_id IN OUT NOCOPY pay_assignment_actions.assignment_action_id%TYPE)
1011: RETURN LONG
1012: IS
1013:
1014: CURSOR csr_prepayment

Line 1020: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;

1016: SELECT MAX(locked_action_id)
1017: FROM pay_action_interlocks
1018: WHERE locking_action_id = p_assignment_action_id;
1019:
1020: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
1021: l_procedure VARCHAR2(50);
1022:
1023: BEGIN
1024:

Line 1043: FROM pay_assignment_actions paa

1039: ,TO_CHAR(decode(pet.processing_type,''R'',greatest(pab.date_start,PTP.START_DATE),pab.date_start),''DD-Mon-YYYY'') COL02
1040: ,TO_CHAR(decode(pet.processing_type,''R'',least(pab.date_end,PTP.END_DATE),pab.date_end),''DD-Mon-YYYY'') COL03
1041: ,TO_CHAR(decode(pet.processing_type,''R'',to_number(prrv.result_value),nvl(pab.absence_days,pab.absence_hours))
1042: ,fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16
1043: FROM pay_assignment_actions paa
1044: ,pay_payroll_actions ppa
1045: ,pay_run_results prr
1046: ,pay_run_result_values prrv
1047: ,per_time_periods ptp

Line 1092: FUNCTION get_messages(p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)

1088: -- Parameters : --
1089: -- IN : p_assignment_action_id NUMBER --
1090: -- --
1091: --------------------------------------------------------------------------
1092: FUNCTION get_messages(p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
1093: RETURN LONG
1094: IS
1095:
1096: CURSOR csr_prepayment

Line 1102: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;

1098: SELECT MAX(locked_action_id)
1099: FROM pay_action_interlocks
1100: WHERE locking_action_id = p_assignment_action_id;
1101:
1102: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
1103: l_procedure VARCHAR2(50);
1104:
1105: BEGIN
1106:

Line 1121: , pay_assignment_actions paa

1117: END IF;
1118:
1119: g_sql := 'SELECT ppa.pay_advice_message COL01
1120: FROM pay_payroll_actions ppa
1121: , pay_assignment_actions paa
1122: WHERE ppa.payroll_action_id = paa.payroll_action_id
1123: AND paa.assignment_action_id = ' || l_assignment_action_id;
1124:
1125: pay_in_utils.set_location (g_debug,'Leaving ' || l_procedure,20);