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_GB_PAYSLIP_ARCHIVE dependencies on PAY_ACTION_INTERLOCKS

Line 1786: pay_action_interlocks pai,

1782: pay_payroll_actions appa,
1783: pay_payroll_actions appa2,
1784: pay_assignment_actions act,
1785: pay_assignment_actions act1,
1786: pay_action_interlocks pai,
1787: per_all_assignments_f as1
1788: WHERE ppa.payroll_action_id = p_pact_id
1789: AND appa.consolidation_set_id = p_consolidation_id
1790: AND appa.effective_date BETWEEN

Line 1808: FROM pay_action_interlocks pai1,

1804: AND act1.payroll_action_id = appa2.payroll_action_id
1805: AND appa2.action_type IN ('P','U') -- Prepayments or Quickpay Prepayments
1806: AND (as1.payroll_id = p_payroll_id OR p_payroll_id IS NULL)
1807: AND NOT EXISTS (SELECT /*+ ORDERED */ NULL
1808: FROM pay_action_interlocks pai1,
1809: pay_assignment_actions act2,
1810: pay_payroll_actions appa3
1811: WHERE pai1.locked_action_id = act.assignment_action_id
1812: AND act2.assignment_action_id = pai1.locking_action_id

Line 1834: pay_action_interlocks pai,

1830: pay_payroll_actions appa,
1831: pay_payroll_actions appa2,
1832: pay_assignment_actions act,
1833: pay_assignment_actions act1,
1834: pay_action_interlocks pai,
1835: per_all_assignments_f as1,
1836: pay_population_ranges ppr
1837: WHERE ppa.payroll_action_id = p_pact_id
1838: AND appa.consolidation_set_id = p_consolidation_id

Line 1858: FROM pay_action_interlocks pai1,

1854: AND act1.payroll_action_id = appa2.payroll_action_id
1855: AND appa2.action_type IN ('P','U') -- Prepayments or Quickpay Prepayments
1856: AND (as1.payroll_id = p_payroll_id OR p_payroll_id IS NULL)
1857: AND NOT EXISTS (SELECT /*+ ORDERED */ NULL
1858: FROM pay_action_interlocks pai1,
1859: pay_assignment_actions act2,
1860: pay_payroll_actions appa3
1861: WHERE pai1.locked_action_id = act.assignment_action_id
1862: AND act2.assignment_action_id = pai1.locking_action_id

Line 2002: FROM pay_action_interlocks pre,

1998: paa.effective_date effective_date,
1999: ppaa.effective_date pre_effective_date,
2000: paa.date_earned date_earned,
2001: paa.time_period_id time_period_id
2002: FROM pay_action_interlocks pre,
2003: pay_action_interlocks pay,
2004: pay_payroll_actions paa,
2005: pay_payroll_actions ppaa,
2006: pay_assignment_actions assact,

Line 2003: pay_action_interlocks pay,

1999: ppaa.effective_date pre_effective_date,
2000: paa.date_earned date_earned,
2001: paa.time_period_id time_period_id
2002: FROM pay_action_interlocks pre,
2003: pay_action_interlocks pay,
2004: pay_payroll_actions paa,
2005: pay_payroll_actions ppaa,
2006: pay_assignment_actions assact,
2007: pay_assignment_actions passact