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

Line 826: SELECT pay_assignment_actions_s.nextval

822: LOOP
823: hr_utility.set_location(' Inside ass action code, inside loop for ref cursor',530);
824: FETCH csr_get_asg INTO l_assg_id;
825: EXIT WHEN csr_get_asg%NOTFOUND;
826: SELECT pay_assignment_actions_s.nextval
827: INTO lockingactid
828: FROM dual;
829:
830: hr_utility.set_location('assignment_action_code, the assignment id finally picked up: '||l_assg_id, 540);

Line 831: -- Insert assignment into PAY_ASSIGNMENT_ACTIONS TABLE

827: INTO lockingactid
828: FROM dual;
829:
830: hr_utility.set_location('assignment_action_code, the assignment id finally picked up: '||l_assg_id, 540);
831: -- Insert assignment into PAY_ASSIGNMENT_ACTIONS TABLE
832: /* hr_nonrun_asact.insact(lockingactid => lockingactid
833: ,assignid => l_assg_id
834: ,pactid => pactid
835: ,chunk => chunk

Line 976: FROM pay_assignment_actions paa,

972: CURSOR cur_valid_asg_act(p_asg_id NUMBER, p_payroll_id NUMBER)
973: IS
974: SELECT /*+ USE_NL(paa, ppa) */
975: max(paa.assignment_action_id) assignment_action_id
976: FROM pay_assignment_actions paa,
977: pay_payroll_actions ppa
978: WHERE paa.assignment_id = p_asg_id
979: AND ppa.payroll_action_id = paa.payroll_action_id
980: AND (paa.source_action_id is not null or ppa.action_type in ('I','V','B'))

Line 2445: FROM pay_assignment_actions paa,

2441: OR g_assignment_set_id IS NULL)
2442: --
2443: and exists (SELECT paa.assignment_action_id child_assignment_action_id,
2444: prt.run_method run_type
2445: FROM pay_assignment_actions paa,
2446: pay_run_types_f prt
2447: WHERE paa.run_type_id = prt.run_type_id
2448: AND prt.run_method IN ('N','P')
2449: AND g_qtr_start_date BETWEEN prt.effective_start_date AND prt.effective_end_date

Line 2452: FROM pay_assignment_actions paa,

2448: AND prt.run_method IN ('N','P')
2449: AND g_qtr_start_date BETWEEN prt.effective_start_date AND prt.effective_end_date
2450: AND paa.assignment_action_id = (SELECT /*+ USE_NL(paa, ppa) */
2451: fnd_number.canonical_to_number(max(paa.assignment_action_id)) child_assignment_action_id
2452: FROM pay_assignment_actions paa,
2453: pay_payroll_actions ppa
2454: WHERE
2455: paa.assignment_id = paaf.assignment_id
2456: AND ppa.payroll_action_id = paa.payroll_action_id

Line 2554: FROM pay_assignment_actions paa,

2550: OR g_assignment_set_id IS NULL)
2551: --
2552: and exists (SELECT paa.assignment_action_id child_assignment_action_id,
2553: prt.run_method run_type
2554: FROM pay_assignment_actions paa,
2555: pay_run_types_f prt
2556: WHERE paa.run_type_id = prt.run_type_id
2557: AND prt.run_method IN ('N','P')
2558: AND g_qtr_start_date BETWEEN prt.effective_start_date AND prt.effective_end_date

Line 2561: FROM pay_assignment_actions paa,

2557: AND prt.run_method IN ('N','P')
2558: AND g_qtr_start_date BETWEEN prt.effective_start_date AND prt.effective_end_date
2559: AND paa.assignment_action_id = (SELECT /*+ USE_NL(paa, ppa) */
2560: fnd_number.canonical_to_number(max(paa.assignment_action_id)) child_assignment_action_id
2561: FROM pay_assignment_actions paa,
2562: pay_payroll_actions ppa
2563: WHERE
2564: paa.assignment_id = paaf.assignment_id
2565: AND ppa.payroll_action_id = paa.payroll_action_id

Line 2671: FROM pay_assignment_actions paa,

2667: /*
2668: and g_qtr_start_date between paaf.effective_start_date and paaf.effective_end_date
2669: and exists (SELECT paa.assignment_action_id child_assignment_action_id,
2670: prt.run_method run_type
2671: FROM pay_assignment_actions paa,
2672: pay_run_types_f prt
2673: WHERE paa.run_type_id = prt.run_type_id
2674: AND prt.run_method IN ('N','P')
2675: AND g_qtr_start_date BETWEEN prt.effective_start_date AND prt.effective_end_date

Line 2678: FROM pay_assignment_actions paa,

2674: AND prt.run_method IN ('N','P')
2675: AND g_qtr_start_date BETWEEN prt.effective_start_date AND prt.effective_end_date
2676: AND paa.assignment_action_id = (SELECT /*+ USE_NL(paa, ppa)
2677: fnd_number.canonical_to_number(max(paa.assignment_action_id)) child_assignment_action_id
2678: FROM pay_assignment_actions paa,
2679: pay_payroll_actions ppa
2680: WHERE
2681: paa.assignment_id = paaf.assignment_id
2682: AND ppa.payroll_action_id = paa.payroll_action_id

Line 2804: FROM pay_assignment_actions paa,

2800: OR g_assignment_set_id IS NULL)
2801: --
2802: and exists (SELECT paa.assignment_action_id child_assignment_action_id,
2803: prt.run_method run_type
2804: FROM pay_assignment_actions paa,
2805: pay_run_types_f prt
2806: WHERE paa.run_type_id = prt.run_type_id
2807: AND prt.run_method IN ('N','P')
2808: AND g_qtr_start_date BETWEEN prt.effective_start_date AND prt.effective_end_date

Line 2811: FROM pay_assignment_actions paa,

2807: AND prt.run_method IN ('N','P')
2808: AND g_qtr_start_date BETWEEN prt.effective_start_date AND prt.effective_end_date
2809: AND paa.assignment_action_id = (SELECT /*+ USE_NL(paa, ppa) */
2810: fnd_number.canonical_to_number(max(paa.assignment_action_id)) child_assignment_action_id
2811: FROM pay_assignment_actions paa,
2812: pay_payroll_actions ppa
2813: WHERE
2814: paa.assignment_id = paaf.assignment_id
2815: AND ppa.payroll_action_id = paa.payroll_action_id