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

Line 837: INDEX(pai PAY_ACTION_INTERLOCKS_FK2)

833: INDEX(as1 PER_ASSIGNMENTS_F_N12)
834: INDEX(ppf PAY_PAYROLLS_F_PK)
835: INDEX(act PAY_ASSIGNMENT_ACTIONS_N51)
836: INDEX(appa PAY_PAYROLL_ACTIONS_PK)
837: INDEX(pai PAY_ACTION_INTERLOCKS_FK2)
838: INDEX(act1 PAY_ASSIGNMENT_ACTIONS_PK)
839: INDEX(appa2 PAY_PAYROLL_ACTIONS_PK)
840: USE_NL(ppa as1 ppf act appa pai act1 appa2) */
841: act.assignment_id assignment_id,

Line 848: pay_action_interlocks pai,

844: FROM pay_payroll_actions ppa,
845: per_all_assignments_f as1,
846: pay_assignment_actions act,
847: pay_payroll_actions appa,
848: pay_action_interlocks pai,
849: pay_assignment_actions act1,
850: pay_payroll_actions appa2,
851: pay_payrolls_f ppf
852: WHERE ppa.payroll_action_id = p_pact_id

Line 879: FROM pay_action_interlocks pai1,

875: AND l_canonical_end_date
876: -- Prepayments or Quickpay Prepayments
877: AND (as1.payroll_id = p_payroll_id OR p_payroll_id IS NULL)
878: AND NOT EXISTS (SELECT /*+ ORDERED */ NULL
879: FROM pay_action_interlocks pai1,
880: pay_assignment_actions act2,
881: pay_payroll_actions appa3
882: WHERE pai1.locked_action_id = act.assignment_action_id
883: AND act2.assignment_action_id= pai1.locking_action_id

Line 889: FROM pay_action_interlocks pai1,

885: AND appa3.action_type = 'X'
886: AND appa3.action_status = 'C'
887: AND appa3.report_type = 'NL_PS_ARCHIVE')
888: AND NOT EXISTS ( SELECT /*+ ORDERED */ NULL
889: FROM pay_action_interlocks pai1,
890: pay_assignment_actions act2,
891: pay_payroll_actions appa3
892: WHERE pai1.locked_action_id = act.assignment_action_id
893: AND act2.assignment_action_id= pai1.locking_action_id

Line 3904: FROM pay_action_interlocks pre,

3900: ppaa.effective_date pre_effective_date,
3901: paa.date_earned date_earned,
3902: paa.time_period_id time_period_id,
3903: paa.payroll_id payroll_id
3904: FROM pay_action_interlocks pre,
3905: pay_action_interlocks pay,
3906: pay_payroll_actions paa,
3907: pay_payroll_actions ppaa,
3908: pay_assignment_actions assact,

Line 3905: pay_action_interlocks pay,

3901: paa.date_earned date_earned,
3902: paa.time_period_id time_period_id,
3903: paa.payroll_id payroll_id
3904: FROM pay_action_interlocks pre,
3905: pay_action_interlocks pay,
3906: pay_payroll_actions paa,
3907: pay_payroll_actions ppaa,
3908: pay_assignment_actions assact,
3909: pay_assignment_actions passact

Line 6070: FROM pay_action_interlocks pre,

6066: ppaa.effective_date pre_effective_date,
6067: paa.date_earned date_earned,
6068: paa.time_period_id time_period_id,
6069: paa.payroll_id payroll_id
6070: FROM pay_action_interlocks pre,
6071: pay_action_interlocks pay,
6072: pay_payroll_actions paa,
6073: pay_payroll_actions ppaa,
6074: pay_assignment_actions assact,

Line 6071: pay_action_interlocks pay,

6067: paa.date_earned date_earned,
6068: paa.time_period_id time_period_id,
6069: paa.payroll_id payroll_id
6070: FROM pay_action_interlocks pre,
6071: pay_action_interlocks pay,
6072: pay_payroll_actions paa,
6073: pay_payroll_actions ppaa,
6074: pay_assignment_actions assact,
6075: pay_assignment_actions passact