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_voluntary_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_voluntary_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 178: FUNCTION get_balances( p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE)

174: -- Parameters : --
175: -- IN : p_assignment_action_id NUMBER --
176: -- --
177: --------------------------------------------------------------------------
178: FUNCTION get_balances( p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE)
179: RETURN LONG
180: IS
181:
182: l_sql LONG;

Line 190: , pay_assignment_actions paa

186: CURSOR csr_get_date_earned
187: IS
188: SELECT ppa.date_earned
189: FROM pay_payroll_actions ppa
190: , pay_assignment_actions paa
191: WHERE ppa.payroll_action_id = paa.payroll_action_id
192: AND paa.assignment_action_id = p_assignment_action_id;
193:
194: CURSOR csr_get_tax_unit_id

Line 199: , pay_assignment_actions paa

195: IS
196: SELECT hsck.segment1
197: FROM hr_soft_coding_keyflex hsck
198: , per_assignments_f paf
199: , pay_assignment_actions paa
200: , pay_payroll_actions ppa
201: WHERE hsck.soft_coding_keyflex_id = paf.soft_coding_keyflex_id
202: AND paa.assignment_action_id = p_assignment_action_id
203: AND paa.payroll_action_id = ppa.payroll_action_id

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

279: -- Parameters : --
280: -- IN : p_assignment_action_id NUMBER --
281: -- --
282: --------------------------------------------------------------------------
283: FUNCTION get_payment_methods(p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE)
284: RETURN LONG
285: IS
286: BEGIN
287:

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

335: -- Parameters : --
336: -- IN : p_assignment_action_id NUMBER --
337: -- --
338: --------------------------------------------------------------------------
339: FUNCTION get_other_element_information(p_assignment_action_id IN OUT NOCOPY pay_assignment_actions.assignment_action_id%TYPE)
340: RETURN LONG
341: IS
342:
343: CURSOR csr_prepayment

Line 349: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;

345: SELECT MAX(locked_action_id)
346: FROM pay_action_interlocks
347: WHERE locking_action_id = p_assignment_action_id;
348:
349: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
350:
351:
352: BEGIN
353:

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

390: -- Parameters : --
391: -- IN : p_assignment_action_id NUMBER --
392: -- --
393: --------------------------------------------------------------------------
394: FUNCTION get_other_balance_information(p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
395: RETURN LONG
396: IS
397:
398: l_date_earned DATE;

Line 406: , pay_assignment_actions paa

402: CURSOR csr_get_date_earned
403: IS
404: SELECT ppa.date_earned, ppa.business_group_id
405: FROM pay_payroll_actions ppa
406: , pay_assignment_actions paa
407: WHERE ppa.payroll_action_id = paa.payroll_action_id
408: AND paa.assignment_action_id = p_assignment_action_id;
409:
410: CURSOR csr_get_tax_unit_id

Line 415: , pay_assignment_actions paa

411: IS
412: SELECT hsck.segment1
413: FROM hr_soft_coding_keyflex hsck
414: , per_assignments_f paf
415: , pay_assignment_actions paa
416: , pay_payroll_actions ppa
417: WHERE hsck.soft_coding_keyflex_id = paf.soft_coding_keyflex_id
418: AND paa.assignment_action_id = p_assignment_action_id
419: AND paa.payroll_action_id = ppa.payroll_action_id

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

467: -- Parameters : --
468: -- IN : p_assignment_action_id NUMBER --
469: -- --
470: --------------------------------------------------------------------------
471: FUNCTION get_annual_leave_information(p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
472: RETURN LONG
473: IS
474:
475: CURSOR csr_get_annual_leave_details(p_payroll_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)

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

471: FUNCTION get_annual_leave_information(p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
472: RETURN LONG
473: IS
474:
475: CURSOR csr_get_annual_leave_details(p_payroll_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
476: IS
477: SELECT pap.accrual_plan_name
478: ,hr_general_utilities.get_lookup_meaning('US_PTO_ACCRUAL',pap.accrual_category)
479: ,hr_general.decode_lookup('HOURS_OR_DAYS',pap.accrual_units_of_measure)

Line 488: ,pay_assignment_actions paa

484: FROM pay_accrual_plans pap
485: ,pay_element_types_f pet
486: ,pay_element_links_f pel
487: ,pay_element_entries_f pee
488: ,pay_assignment_actions paa
489: ,pay_payroll_actions ppa
490: WHERE pet.element_type_id = pap.accrual_plan_element_type_id
491: AND pel.element_type_id = pet.element_type_id
492: AND pee.element_link_id = pel.element_link_id

Line 509: , pay_assignment_actions paa

505: CURSOR csr_get_date_earned
506: IS
507: SELECT ppa.date_earned
508: FROM pay_payroll_actions ppa
509: , pay_assignment_actions paa
510: WHERE ppa.payroll_action_id = paa.payroll_action_id
511: AND paa.assignment_action_id = p_assignment_action_id;
512:
513: CURSOR csr_prepayment

Line 526: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;

522: l_payroll_id pay_payrolls_f.payroll_id%TYPE;
523: l_business_group_id per_business_groups.business_group_id%TYPE;
524: l_accrual_plan_id pay_accrual_plans.accrual_plan_id%TYPE;
525: l_assignment_id per_assignments_f.assignment_id%TYPE;
526: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
527: l_annual_leave_balance NUMBER;
528: l_ovn NUMBER;
529: l_leave_taken NUMBER;
530: l_start_date DATE;

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

593: -- Parameters : --
594: -- IN : p_assignment_action_id NUMBER --
595: -- --
596: --------------------------------------------------------------------------
597: FUNCTION get_leave_taken(p_assignment_action_id IN OUT NOCOPY pay_assignment_actions.assignment_action_id%TYPE)
598: RETURN LONG
599: IS
600:
601: CURSOR csr_prepayment

Line 607: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;

603: SELECT MAX(locked_action_id)
604: FROM pay_action_interlocks
605: WHERE locking_action_id = p_assignment_action_id;
606:
607: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
608:
609: BEGIN
610:
611: OPEN csr_prepayment;

Line 626: FROM pay_assignment_actions paa

622: ,TO_CHAR(decode(pet.processing_type,''R'',greatest(pab.date_start,PTP.START_DATE),pab.date_start),''DD-Mon-YYYY'') COL02
623: ,TO_CHAR(decode(pet.processing_type,''R'',least(pab.date_end,PTP.END_DATE),pab.date_end),''DD-Mon-YYYY'') COL03
624: ,TO_CHAR(decode(pet.processing_type,''R'',to_number(prrv.result_value),nvl(pab.absence_days,pab.absence_hours))
625: ,fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16
626: FROM pay_assignment_actions paa
627: ,pay_payroll_actions ppa
628: ,pay_run_results prr
629: ,pay_run_result_values prrv
630: ,per_time_periods ptp

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

670: -- Parameters : --
671: -- IN : p_assignment_action_id NUMBER --
672: -- --
673: --------------------------------------------------------------------------
674: FUNCTION get_messages(p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
675: RETURN LONG
676: IS
677:
678: CURSOR csr_prepayment

Line 684: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;

680: SELECT MAX(locked_action_id)
681: FROM pay_action_interlocks
682: WHERE locking_action_id = p_assignment_action_id;
683:
684: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
685:
686: BEGIN
687:
688:

Line 699: , pay_assignment_actions paa

695: END IF;
696:
697: g_sql := 'SELECT ppa.pay_advice_message COL01
698: FROM pay_payroll_actions ppa
699: , pay_assignment_actions paa
700: WHERE ppa.payroll_action_id = paa.payroll_action_id
701: AND paa.assignment_action_id = ' || l_assignment_action_id;
702:
703: RETURN g_sql;