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_ASSIGNMENT_ACTIONS

Line 835: INDEX(act PAY_ASSIGNMENT_ACTIONS_N51)

831: SELECT /*+ ORDERED
832: INDEX(ppa PAY_PAYROLL_ACTIONS_PK)
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)

Line 838: INDEX(act1 PAY_ASSIGNMENT_ACTIONS_PK)

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,
842: act.assignment_action_id run_action_id,

Line 846: pay_assignment_actions act,

842: act.assignment_action_id run_action_id,
843: act1.assignment_action_id prepaid_action_id
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,

Line 849: pay_assignment_actions act1,

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
853: AND appa.consolidation_set_id = p_consolidation_id

Line 880: pay_assignment_actions act2,

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
884: AND act2.payroll_action_id = appa3.payroll_action_id

Line 890: pay_assignment_actions act2,

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
894: AND act2.payroll_action_id = appa3.payroll_action_id

Line 905: from pay_assignment_Actions paa

901: --Bug 3384315
902: CURSOR get_prepayment_child_action(p_source_action_id NUMBER
903: ,p_assignment_id NUMBER) IS
904: select paa.assignment_action_id
905: from pay_assignment_Actions paa
906: ,pay_assignment_Actions paa1
907: where paa.source_action_id=p_source_action_id
908: and paa1.assignment_id <> p_assignment_id
909: and paa.assignment_id=p_assignment_id

Line 906: ,pay_assignment_Actions paa1

902: CURSOR get_prepayment_child_action(p_source_action_id NUMBER
903: ,p_assignment_id NUMBER) IS
904: select paa.assignment_action_id
905: from pay_assignment_Actions paa
906: ,pay_assignment_Actions paa1
907: where paa.source_action_id=p_source_action_id
908: and paa1.assignment_id <> p_assignment_id
909: and paa.assignment_id=p_assignment_id
910: and paa1.assignment_action_id=p_source_action_id;

Line 963: SELECT pay_assignment_actions_s.NEXTVAL

959:
960: IF l_prepay_action_id <> csr_rec.prepaid_action_id THEN
961: --
962:
963: SELECT pay_assignment_actions_s.NEXTVAL
964: INTO l_actid
965: FROM dual;
966: --
967: -- Create the archive assignment action

Line 2913: FROM pay_assignment_actions paa

2909: ,p_payroll_action_id NUMBER
2910: ,p_assignment_id NUMBER
2911: ,p_effective_date DATE) IS
2912: SELECT paa.assignment_action_id np_assignment_action_id
2913: FROM pay_assignment_actions paa
2914: ,pay_run_types_f prt
2915: WHERE paa.source_action_id = p_assignment_action_id
2916: AND paa.payroll_action_id = p_payroll_action_id
2917: AND paa.assignment_id = p_assignment_id

Line 3880: FROM pay_assignment_actions paa

3876: ,p_payroll_action_id NUMBER
3877: ,p_assignment_id NUMBER
3878: ,p_effective_date DATE) IS
3879: SELECT paa.assignment_action_id np_assignment_action_id
3880: FROM pay_assignment_actions paa
3881: ,pay_run_types_f prt
3882: WHERE paa.source_action_id = p_assignment_action_id
3883: AND paa.payroll_action_id = p_payroll_action_id
3884: AND paa.assignment_id = p_assignment_id

Line 3908: pay_assignment_actions assact,

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
3910: WHERE pre.locked_action_id = pay.locking_action_id
3911: AND pre.locking_action_id = lp_locking_action_id
3912: AND pre.locked_action_id = passact.assignment_action_id

Line 3909: pay_assignment_actions passact

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
3910: WHERE pre.locked_action_id = pay.locking_action_id
3911: AND pre.locking_action_id = lp_locking_action_id
3912: AND pre.locked_action_id = passact.assignment_action_id
3913: AND passact.assignment_id =assact.assignment_id

Line 4497: FROM pay_assignment_actions paa

4493: ,p_payroll_action_id NUMBER
4494: ,p_assignment_id NUMBER
4495: ,p_effective_date DATE) IS
4496: SELECT paa.assignment_action_id np_assignment_action_id
4497: FROM pay_assignment_actions paa
4498: ,pay_run_types_f prt
4499: WHERE paa.source_action_id = p_assignment_action_id
4500: AND paa.payroll_action_id = p_payroll_action_id
4501: AND paa.assignment_id = p_assignment_id

Line 6074: pay_assignment_actions assact,

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
6076: WHERE pre.locked_action_id = pay.locking_action_id
6077: AND pre.locking_action_id = p_locking_action_id
6078: AND pre.locked_action_id = passact.assignment_action_id

Line 6075: pay_assignment_actions passact

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
6076: WHERE pre.locked_action_id = pay.locking_action_id
6077: AND pre.locking_action_id = p_locking_action_id
6078: AND pre.locked_action_id = passact.assignment_action_id
6079: AND passact.assignment_id =assact.assignment_id

Line 6091: pay_assignment_Actions paa,

6087: cursor csr_get_max_assignment_action(p_assignment_action_id NUMBER)
6088: is
6089: select max(paa.assignment_Action_id) max_assact from
6090: pay_payroll_actions ppa,
6091: pay_assignment_Actions paa,
6092: pay_assignment_Actions paa1
6093: where paa1.assignment_Action_id = p_assignment_action_id
6094: and paa1.payroll_action_id = ppa.payroll_action_id
6095: and paa.assignment_id = paa1.assignment_id

Line 6092: pay_assignment_Actions paa1

6088: is
6089: select max(paa.assignment_Action_id) max_assact from
6090: pay_payroll_actions ppa,
6091: pay_assignment_Actions paa,
6092: pay_assignment_Actions paa1
6093: where paa1.assignment_Action_id = p_assignment_action_id
6094: and paa1.payroll_action_id = ppa.payroll_action_id
6095: and paa.assignment_id = paa1.assignment_id
6096: and paa.payroll_action_id = ppa.payroll_action_id;

Line 6108: FROM pay_assignment_actions paa,

6104: p_assignment_id NUMBER,
6105: p_effective_date DATE ) IS
6106: SELECT paa.assignment_action_id child_assignment_action_id,
6107: 'S' run_type
6108: FROM pay_assignment_actions paa,
6109: pay_run_types_f prt
6110: WHERE paa.source_action_id = p_master_assignment_action
6111: AND paa.payroll_action_id = p_payroll_action_id
6112: AND paa.assignment_id = p_assignment_id

Line 6120: FROM pay_assignment_actions paa

6116: AND prt.effective_end_date
6117: UNION
6118: SELECT paa.assignment_action_id child_assignment_action_id,
6119: 'NP' run_type --Standard Run, Process Separate Run
6120: FROM pay_assignment_actions paa
6121: WHERE paa.payroll_action_id = p_payroll_action_id
6122: AND paa.assignment_id = p_assignment_id
6123: AND paa.action_sequence = (
6124: SELECT MAX(paa1.action_sequence)

Line 6125: FROM pay_assignment_actions paa1,

6121: WHERE paa.payroll_action_id = p_payroll_action_id
6122: AND paa.assignment_id = p_assignment_id
6123: AND paa.action_sequence = (
6124: SELECT MAX(paa1.action_sequence)
6125: FROM pay_assignment_actions paa1,
6126: pay_run_types_f prt1
6127: WHERE prt1.run_type_id = paa1.run_type_id
6128: AND prt1.run_method IN ('N','P')
6129: AND paa1.payroll_action_id = p_payroll_action_id

Line 6145: FROM pay_assignment_actions paa

6141: ,p_assignment_id NUMBER
6142: ,p_effective_date DATE) IS
6143: SELECT paa.assignment_action_id np_assignment_action_id,
6144: prt.run_method run_method
6145: FROM pay_assignment_actions paa
6146: ,pay_run_types_f prt
6147: WHERE paa.source_action_id = p_assignment_action_id
6148: AND paa.payroll_action_id = p_payroll_action_id
6149: AND paa.assignment_id = p_assignment_id

Line 6163: ,pay_assignment_actions paa

6159: ptp.regular_payment_date regular_payment_date,
6160: ptp.time_period_id time_period_id
6161: FROM per_time_periods ptp
6162: ,pay_payroll_actions ppa
6163: ,pay_assignment_actions paa
6164: WHERE ptp.payroll_id =ppa.payroll_id
6165: AND ppa.payroll_action_id =paa.payroll_action_id
6166: And paa.assignment_action_id =p_assignment_action_id
6167: AND ppa.date_earned BETWEEN ptp.start_date AND ptp.end_date;

Line 6222: FROM pay_assignment_actions paa

6218: -- Retrieve the chunk number for the current assignment action
6219: --
6220: SELECT paa.chunk_number
6221: INTO l_chunk_number
6222: FROM pay_assignment_actions paa
6223: WHERE paa.assignment_action_id = p_assignment_action_id;
6224: --
6225: l_record_count := 0;
6226: l_archive_stat := 0;