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.PER_MX_SS_AFFILIATION dependencies on PAY_ACTION_INTERLOCKS

Line 461: pay_action_interlocks lck

457: AND fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',p_end_date,g_end_date))
458: /*NOT EXISTS (SELECT 'X'
459: FROM pay_payroll_actions ppa_affl,
460: pay_assignment_actions paa_affl,
461: pay_action_interlocks lck
462: WHERE lck.locked_action_id = pai.action_context_id
463: AND lck.locking_action_id = paa_affl.assignment_action_id
464: AND paa_affl.payroll_action_id = ppa_affl.payroll_action_id
465: AND ppa_affl.report_type = 'MX_SS_AFFL'

Line 517: pay_action_interlocks lck

513: AND trunc(fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',p_end_date,g_end_date)))
514: /*NOT EXISTS (SELECT 'X'
515: FROM pay_payroll_actions ppa_affl,
516: pay_assignment_actions paa_affl,
517: pay_action_interlocks lck
518: WHERE lck.locked_action_id = pai.action_context_id
519: AND lck.locking_action_id = paa_affl.assignment_action_id
520: AND paa_affl.payroll_action_id = ppa_affl.payroll_action_id
521: AND ppa_affl.report_type = 'MX_SS_AFFL'

Line 542: the Archiver Assignment action has been already locked in pay_action_interlocks*/

538: decode (paf.primary_flag, 'Y', 1, 2),
539: paf.assignment_id;
540:
541: /*Bug 8768679 - The following cursor has been added to find out if
542: the Archiver Assignment action has been already locked in pay_action_interlocks*/
543:
544: CURSOR c_assg_action_exist (p_arch_asg_act NUMBER) IS
545: SELECT count(*)
546: FROM pay_action_interlocks

Line 546: FROM pay_action_interlocks

542: the Archiver Assignment action has been already locked in pay_action_interlocks*/
543:
544: CURSOR c_assg_action_exist (p_arch_asg_act NUMBER) IS
545: SELECT count(*)
546: FROM pay_action_interlocks
547: WHERE locked_action_id = p_arch_asg_act;
548:
549: /*Bug 8768679 - The follwowing cursor has been added to find out if
550: the archiver assignment action has already been locked by another

Line 557: pay_action_interlocks pail

553: CURSOR c_report_type (p_arch_asg_act NUMBER) IS
554: SELECT count(*)
555: FROM pay_payroll_actions pact,
556: pay_assignment_actions paa,
557: pay_action_interlocks pail
558: WHERE p_arch_asg_act = pail.locked_action_id
559: AND pail.locking_action_id = paa.assignment_action_id
560: AND paa.payroll_action_id = pact.payroll_action_id
561: AND pact.report_type = 'MX_SS_AFFL';

Line 781: pay_action_interlocks lck,

777: SELECT nvl(fnd_number.canonical_to_number(pai.action_information8),-1)
778: FROM pay_payroll_actions ppa_mag,
779: pay_assignment_actions paa_mag,
780: --pay_assignment_actions paa_arch,
781: pay_action_interlocks lck,
782: pay_action_information pai
783: WHERE ppa_mag.payroll_action_id = paa_mag.payroll_action_id
784: AND paa_mag.assignment_action_id = lck.locking_action_id
785: /*AND lck.locked_action_id = paa_arch.assignment_action_id

Line 985: pay_action_interlocks lck*/

981: pai.action_information18 -- Salary Type
982: -- Bug 6065124
983: FROM pay_action_information pai /*,
984: pay_assignment_actions paa_arch,
985: pay_action_interlocks lck*/
986: WHERE pai.action_information_category = 'MX SS PERSON INFORMATION'
987: /*and lck.locking_action_id = cp_assignment_action_id
988: AND lck.locked_action_id = pai.action_context_id*/
989: AND pai.action_context_type = 'AAP'

Line 1010: pay_action_interlocks lck

1006: ppa.legislative_parameters))
1007: FROM pay_payroll_actions ppa,
1008: pay_assignment_actions paa,
1009: pay_action_information pai,
1010: pay_action_interlocks lck
1011: WHERE paa.payroll_action_id = ppa.payroll_action_id
1012: AND paa.assignment_action_id = lck.locking_action_id
1013: AND pai.action_context_id = lck.locked_action_id
1014: AND pai.action_information_category = 'MX SS PERSON INFORMATION'

Line 1079: pay_action_interlocks lck

1075: fnd_number.canonical_to_number (pai.action_information8), -- IDW
1076: pai.action_information9, -- Leaving reason
1077: pai.action_information24 -- Reporting option (YES/NO)
1078: FROM pay_action_information pai,
1079: pay_action_interlocks lck
1080: WHERE lck.locking_action_id = cp_assignment_action_id
1081: AND lck.locked_action_id = pai.action_context_id
1082: AND pai.action_information_category = 'MX SS TRANSACTIONS'
1083: AND pai.action_information4 IN ('02', '07', '08')

Line 1103: pay_action_interlocks lck

1099: AND fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',cp_end_date,g_end_date))
1100: /*NOT EXISTS (SELECT 'X'
1101: FROM pay_payroll_actions ppa_affl,
1102: pay_assignment_actions paa_affl,
1103: pay_action_interlocks lck
1104: WHERE lck.locked_action_id = pai.action_context_id
1105: AND lck.locking_action_id = paa_affl.assignment_action_id
1106: AND paa_affl.payroll_action_id = ppa_affl.payroll_action_id
1107: AND ppa_affl.report_type = 'MX_SS_AFFL'

Line 1379: pay_action_interlocks lck,

1375:
1376: CURSOR csr_employer IS
1377: SELECT pai.action_information_id
1378: FROM pay_action_information pai,
1379: pay_action_interlocks lck,
1380: pay_assignment_actions paa_affl,
1381: pay_assignment_actions paa_arch
1382: WHERE paa_affl.payroll_action_id =
1383: pay_magtape_generic.get_parameter_value ('PAYROLL_ACTION_ID')