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_AU_PAYMENT_SUMMARY_AMEND dependencies on PER_ASSIGNMENTS_F

Line 276: FROM per_assignments_f paf

272: ,c_financial_year IN VARCHAR2
273: ,c_tax_unit_id IN pay_assignment_actions.tax_unit_iD%TYPE)
274: IS
275: SELECT DISTINCT paf.assignment_id
276: FROM per_assignments_f paf
277: ,per_people_f ppf
278: ,pay_payroll_actions ppa
279: WHERE ppa.payroll_action_id = c_payroll_action_id
280: AND ppf.person_id BETWEEN c_start_person_id AND c_end_person_id

Line 322: FROM per_assignments_f paf

318: ,c_financial_year IN VARCHAR2
319: ,c_tax_unit_id IN pay_assignment_actions.tax_unit_iD%TYPE)
320: IS
321: SELECT DISTINCT paf.assignment_id
322: FROM per_assignments_f paf
323: ,per_people_f ppf
324: ,pay_payroll_actions ppa
325: WHERE ppa.payroll_action_id = c_payroll_action_id
326: AND ppf.person_id BETWEEN c_start_person_id AND c_end_person_id

Line 353: FROM per_assignments_f paf

349: ,c_financial_year IN VARCHAR2
350: ,c_tax_unit_id IN pay_assignment_actions.tax_unit_iD%TYPE)
351: IS
352: SELECT DISTINCT paf.assignment_id
353: FROM per_assignments_f paf
354: ,per_people_f ppf
355: ,pay_payroll_actions ppa
356: ,hr_assignment_set_amendments has
357: WHERE ppa.payroll_action_id = c_payroll_action_id

Line 402: FROM per_assignments_f paf

398: ,c_financial_year IN VARCHAR2
399: ,c_tax_unit_id IN pay_assignment_actions.tax_unit_iD%TYPE)
400: IS
401: SELECT DISTINCT paf.assignment_id
402: FROM per_assignments_f paf
403: ,per_people_f ppf
404: ,pay_payroll_actions ppa
405: ,hr_assignment_set_amendments has
406: WHERE ppa.payroll_action_id = c_payroll_action_id

Line 440: INDEX(PAF PER_ASSIGNMENTS_F_N12)

436: SELECT /*+ ORDERED
437: USE_NL(PPA, PPR, PAF, HAS)
438: INDEX(PPA PAY_PAYROLL_ACTIONS_PK)
439: INDEX(PPR PAY_POPULATION_RANGES_N4)
440: INDEX(PAF PER_ASSIGNMENTS_F_N12)
441: INDEX(HAS HR_ASSIGNMENT_SET_AMENDMEN_PK) */
442: paf.assignment_id
443: FROM pay_payroll_actions ppa,
444: pay_population_ranges ppr,

Line 445: per_assignments_f paf,

441: INDEX(HAS HR_ASSIGNMENT_SET_AMENDMEN_PK) */
442: paf.assignment_id
443: FROM pay_payroll_actions ppa,
444: pay_population_ranges ppr,
445: per_assignments_f paf,
446: hr_assignment_set_amendments has
447: WHERE ppa.payroll_action_id = c_payroll_action_id
448: AND ppr.payroll_action_id = ppa.payroll_action_id
449: AND ppr.chunk_number = c_chunk

Line 507: INDEX(PAF PER_ASSIGNMENTS_F_N12)

503: SELECT /*+ ORDERED
504: USE_NL(PPA, PPR, PAF, HAS)
505: INDEX(PPA PAY_PAYROLL_ACTIONS_PK)
506: INDEX(PPR PAY_POPULATION_RANGES_N4)
507: INDEX(PAF PER_ASSIGNMENTS_F_N12)
508: INDEX(HAS HR_ASSIGNMENT_SET_AMENDMEN_PK) */
509: paf.assignment_id
510: FROM pay_payroll_actions ppa,
511: pay_population_ranges ppr,

Line 512: per_assignments_f paf,

508: INDEX(HAS HR_ASSIGNMENT_SET_AMENDMEN_PK) */
509: paf.assignment_id
510: FROM pay_payroll_actions ppa,
511: pay_population_ranges ppr,
512: per_assignments_f paf,
513: hr_assignment_set_amendments has
514: WHERE ppa.payroll_action_id = c_payroll_action_id
515: AND ppr.payroll_action_id = ppa.payroll_action_id
516: AND ppr.chunk_number = c_chunk