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

Line 27: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;

23: ,p_classification_name IN VARCHAR2
24: ) RETURN LONG
25: IS
26: l_procedure VARCHAR2(50);
27: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
28:
29: CURSOR csr_prepayments_action_id
30: IS
31: SELECT locking_action_id

Line 71: FUNCTION get_taxable_earnings(p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)

67: -- Parameters : --
68: -- IN : p_assignment_action_id NUMBER --
69: -- --
70: --------------------------------------------------------------------------
71: FUNCTION get_taxable_earnings(p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
72: RETURN LONG
73: IS
74: l_procedure VARCHAR2(50);
75: BEGIN

Line 98: FUNCTION get_non_taxable_earnings(p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)

94: -- Parameters : --
95: -- IN : p_assignment_action_id NUMBER --
96: -- --
97: --------------------------------------------------------------------------
98: FUNCTION get_non_taxable_earnings(p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
99: RETURN LONG
100: IS
101: l_procedure VARCHAR2(50);
102: BEGIN

Line 125: FUNCTION get_statutory_deductions(p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)

121: -- Parameters : --
122: -- IN : p_assignment_action_id NUMBER --
123: -- --
124: --------------------------------------------------------------------------
125: FUNCTION get_statutory_deductions(p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
126: RETURN LONG
127: IS
128: l_procedure VARCHAR2(50);
129: BEGIN

Line 152: FUNCTION get_non_statutory_deductions(p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)

148: -- Parameters : --
149: -- IN : p_assignment_action_id NUMBER --
150: -- --
151: --------------------------------------------------------------------------
152: FUNCTION get_non_statutory_deductions(p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
153: RETURN LONG
154: IS
155: l_procedure VARCHAR2(50);
156: BEGIN

Line 179: FUNCTION get_voluntary_deductions(p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)

175: -- Parameters : --
176: -- IN : p_assignment_action_id NUMBER --
177: -- --
178: --------------------------------------------------------------------------
179: FUNCTION get_voluntary_deductions(p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
180: RETURN LONG
181: IS
182: l_procedure VARCHAR2(50);
183: BEGIN

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

201: -- Parameters : --
202: -- IN : p_assignment_action_id NUMBER --
203: -- --
204: --------------------------------------------------------------------------
205: FUNCTION get_balances( p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE)
206: RETURN LONG
207: IS
208:
209: l_sql LONG;

Line 217: , pay_assignment_actions paa

213: CURSOR csr_get_date_earned
214: IS
215: SELECT ppa.date_earned
216: FROM pay_payroll_actions ppa
217: , pay_assignment_actions paa
218: WHERE ppa.payroll_action_id = paa.payroll_action_id
219: AND paa.assignment_action_id = p_assignment_action_id;
220:
221: CURSOR csr_get_tax_unit_id

Line 226: , pay_assignment_actions paa

222: IS
223: SELECT hsck.segment1
224: FROM hr_soft_coding_keyflex hsck
225: , per_assignments_f paf
226: , pay_assignment_actions paa
227: , pay_payroll_actions ppa
228: WHERE hsck.soft_coding_keyflex_id = paf.soft_coding_keyflex_id
229: AND paa.assignment_action_id = p_assignment_action_id
230: AND paa.payroll_action_id = ppa.payroll_action_id

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

308: -- Parameters : --
309: -- IN : p_assignment_action_id NUMBER --
310: -- --
311: --------------------------------------------------------------------------
312: FUNCTION get_payment_methods(p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE)
313: RETURN LONG
314: IS
315: BEGIN
316:

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

364: -- Parameters : --
365: -- IN : p_assignment_action_id NUMBER --
366: -- --
367: --------------------------------------------------------------------------
368: FUNCTION get_other_element_information(p_assignment_action_id IN OUT NOCOPY pay_assignment_actions.assignment_action_id%TYPE)
369: RETURN LONG
370: IS
371:
372: CURSOR csr_prepayment

Line 378: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;

374: SELECT MAX(locked_action_id)
375: FROM pay_action_interlocks
376: WHERE locking_action_id = p_assignment_action_id;
377:
378: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
379:
380:
381: BEGIN
382:

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

419: -- Parameters : --
420: -- IN : p_assignment_action_id NUMBER --
421: -- --
422: --------------------------------------------------------------------------
423: FUNCTION get_other_balance_information(p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
424: RETURN LONG
425: IS
426:
427: l_date_earned DATE;

Line 435: , pay_assignment_actions paa

431: CURSOR csr_get_date_earned
432: IS
433: SELECT ppa.date_earned, ppa.business_group_id
434: FROM pay_payroll_actions ppa
435: , pay_assignment_actions paa
436: WHERE ppa.payroll_action_id = paa.payroll_action_id
437: AND paa.assignment_action_id = p_assignment_action_id;
438:
439: CURSOR csr_get_tax_unit_id

Line 444: , pay_assignment_actions paa

440: IS
441: SELECT hsck.segment1
442: FROM hr_soft_coding_keyflex hsck
443: , per_assignments_f paf
444: , pay_assignment_actions paa
445: , pay_payroll_actions ppa
446: WHERE hsck.soft_coding_keyflex_id = paf.soft_coding_keyflex_id
447: AND paa.assignment_action_id = p_assignment_action_id
448: AND paa.payroll_action_id = ppa.payroll_action_id

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

496: -- Parameters : --
497: -- IN : p_assignment_action_id NUMBER --
498: -- --
499: --------------------------------------------------------------------------
500: FUNCTION get_annual_leave_information(p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
501: RETURN LONG
502: IS
503:
504: CURSOR csr_get_annual_leave_details(p_payroll_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)

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

500: FUNCTION get_annual_leave_information(p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
501: RETURN LONG
502: IS
503:
504: CURSOR csr_get_annual_leave_details(p_payroll_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
505: IS
506: SELECT pap.accrual_plan_name
507: ,hr_general_utilities.get_lookup_meaning('US_PTO_ACCRUAL',pap.accrual_category)
508: ,hr_general.decode_lookup('HOURS_OR_DAYS',pap.accrual_units_of_measure)

Line 517: ,pay_assignment_actions paa

513: FROM pay_accrual_plans pap
514: ,pay_element_types_f pet
515: ,pay_element_links_f pel
516: ,pay_element_entries_f pee
517: ,pay_assignment_actions paa
518: ,pay_payroll_actions ppa
519: WHERE pet.element_type_id = pap.accrual_plan_element_type_id
520: AND pel.element_type_id = pet.element_type_id
521: AND pee.element_link_id = pel.element_link_id

Line 534: CURSOR csr_get_annual_leave_R12(p_payroll_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)

530: AND ppa.date_earned BETWEEN pee.effective_start_date
531: AND pee.effective_end_date
532: AND paa.assignment_action_id = p_payroll_assignment_action_id;
533:
534: CURSOR csr_get_annual_leave_R12(p_payroll_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
535: IS
536: SELECT paptl.accrual_plan_name
537: ,hr_general_utilities.get_lookup_meaning('US_PTO_ACCRUAL',pap.accrual_category)
538: ,hr_general.decode_lookup('HOURS_OR_DAYS',pap.accrual_units_of_measure)

Line 548: ,pay_assignment_actions paa

544: ,pay_accrual_plans_tl paptl
545: ,pay_element_types_f pet
546: ,pay_element_links_f pel
547: ,pay_element_entries_f pee
548: ,pay_assignment_actions paa
549: ,pay_payroll_actions ppa
550: WHERE pet.element_type_id = pap.accrual_plan_element_type_id
551: AND pel.element_type_id = pet.element_type_id
552: AND pee.element_link_id = pel.element_link_id

Line 571: , pay_assignment_actions paa

567: CURSOR csr_get_date_earned
568: IS
569: SELECT ppa.date_earned
570: FROM pay_payroll_actions ppa
571: , pay_assignment_actions paa
572: WHERE ppa.payroll_action_id = paa.payroll_action_id
573: AND paa.assignment_action_id = p_assignment_action_id;
574:
575: CURSOR csr_prepayment

Line 588: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;

584: l_payroll_id pay_payrolls_f.payroll_id%TYPE;
585: l_business_group_id per_business_groups.business_group_id%TYPE;
586: l_accrual_plan_id pay_accrual_plans.accrual_plan_id%TYPE;
587: l_assignment_id per_assignments_f.assignment_id%TYPE;
588: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
589: l_annual_leave_balance NUMBER;
590: l_ovn NUMBER;
591: l_leave_taken NUMBER;
592: l_start_date DATE;

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

676: -- Parameters : --
677: -- IN : p_assignment_action_id NUMBER --
678: -- --
679: --------------------------------------------------------------------------
680: FUNCTION get_leave_taken(p_assignment_action_id IN OUT NOCOPY pay_assignment_actions.assignment_action_id%TYPE)
681: RETURN LONG
682: IS
683:
684: CURSOR csr_prepayment

Line 690: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;

686: SELECT MAX(locked_action_id)
687: FROM pay_action_interlocks
688: WHERE locking_action_id = p_assignment_action_id;
689:
690: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
691:
692: BEGIN
693:
694: OPEN csr_prepayment;

Line 709: FROM pay_assignment_actions paa

705: ,TO_CHAR(decode(pet.processing_type,''R'',greatest(pab.date_start,PTP.START_DATE),pab.date_start),''DD-Mon-YYYY'') COL02
706: ,TO_CHAR(decode(pet.processing_type,''R'',least(pab.date_end,PTP.END_DATE),pab.date_end),''DD-Mon-YYYY'') COL03
707: ,TO_CHAR(decode(pet.processing_type,''R'',to_number(prrv.result_value),nvl(pab.absence_days,pab.absence_hours))
708: ,fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16
709: FROM pay_assignment_actions paa
710: ,pay_payroll_actions ppa
711: ,pay_run_results prr
712: ,pay_run_result_values prrv
713: ,per_time_periods ptp

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

754: -- Parameters : --
755: -- IN : p_assignment_action_id NUMBER --
756: -- --
757: --------------------------------------------------------------------------
758: FUNCTION get_messages(p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
759: RETURN LONG
760: IS
761:
762: CURSOR csr_prepayment

Line 768: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;

764: SELECT MAX(locked_action_id)
765: FROM pay_action_interlocks
766: WHERE locking_action_id = p_assignment_action_id;
767:
768: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
769:
770: BEGIN
771:
772:

Line 783: , pay_assignment_actions paa

779: END IF;
780:
781: g_sql := 'SELECT ppa.pay_advice_message COL01
782: FROM pay_payroll_actions ppa
783: , pay_assignment_actions paa
784: WHERE ppa.payroll_action_id = paa.payroll_action_id
785: AND paa.assignment_action_id = ' || l_assignment_action_id;
786:
787: RETURN g_sql;