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_ASSIGNMENT_ACTIONS

Line 460: pay_assignment_actions paa_affl,

456: /*Bug 8768679*/
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

Line 516: pay_assignment_actions paa_affl,

512: /*Bug 8768679*/
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

Line 556: pay_assignment_actions paa,

552:
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

Line 668: SELECT pay_assignment_actions_s.nextval

664: The following IF condition is used for that purpose.*/
665:
666: IF (ln_exist = 0 OR l_report = 0) THEN
667: IF (ln_person_id <> ln_prev_person_id) THEN
668: SELECT pay_assignment_actions_s.nextval
669: INTO ln_affl_asg_act
670: FROM dual;
671:
672: hr_utility_trace('Creating affiliation report assignment action '||

Line 779: pay_assignment_actions paa_mag,

775:
776: CURSOR csr_prev_idw(cp_gre_token VARCHAR2) IS
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

Line 780: --pay_assignment_actions paa_arch,

776: CURSOR csr_prev_idw(cp_gre_token VARCHAR2) IS
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

Line 984: pay_assignment_actions paa_arch,

980: fnd_number.canonical_to_number(pai.action_information11), -- IDW
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*/

Line 1008: pay_assignment_actions paa,

1004: fnd_date.canonical_to_date(
1005: pay_mx_utility.get_legi_param_val('END_DATE',
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

Line 1062: pay_assignment_actions paa

1058:
1059: CURSOR csr_person (cp_assignment_action_id number) IS
1060: SELECT paf.person_id
1061: FROM per_assignments_f paf,
1062: pay_assignment_actions paa
1063: WHERE paa.assignment_action_id = cp_assignment_action_id
1064: AND paa.assignment_id = paf.assignment_id;
1065:
1066: /*Bug 8768679 - The employee 08 transactions would be picked up only when the hire date lies within the

Line 1102: pay_assignment_actions paa_affl,

1098: /*Bug 8768679*/
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

Line 1380: pay_assignment_actions paa_affl,

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')
1384: AND lck.locking_action_id = paa_affl.assignment_action_id

Line 1381: pay_assignment_actions paa_arch

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')
1384: AND lck.locking_action_id = paa_affl.assignment_action_id
1385: AND paa_arch.assignment_action_id = lck.locked_action_id