APPS.PER_MX_SS_AFFILIATION dependencies on PAY_ASSIGNMENT_ACTIONS

Line 427: pay_assignment_actions paa_affl,

423: fnd_date.canonical_to_date (g_start_date)
424: AND fnd_date.canonical_to_date (g_end_date)
425: /*NOT EXISTS (SELECT 'X'
426: FROM pay_payroll_actions ppa_affl,
427: pay_assignment_actions paa_affl,
428: pay_action_interlocks lck
429: WHERE lck.locked_action_id = pai.action_context_id
430: AND lck.locking_action_id = paa_affl.assignment_action_id
431: AND paa_affl.payroll_action_id = ppa_affl.payroll_action_id

Line 479: pay_assignment_actions paa_affl,

475: fnd_date.canonical_to_date (g_start_date)
476: AND fnd_date.canonical_to_date (g_end_date)
477: /*NOT EXISTS (SELECT 'X'
478: FROM pay_payroll_actions ppa_affl,
479: pay_assignment_actions paa_affl,
480: pay_action_interlocks lck
481: WHERE lck.locked_action_id = pai.action_context_id
482: AND lck.locking_action_id = paa_affl.assignment_action_id
483: AND paa_affl.payroll_action_id = ppa_affl.payroll_action_id

Line 571: SELECT pay_assignment_actions_s.nextval

567: hr_utility_trace('Current person = '||ln_person_id);
568: hr_utility_trace('Previous person = '||ln_prev_person_id);
569:
570: IF (ln_person_id <> ln_prev_person_id) THEN
571: SELECT pay_assignment_actions_s.nextval
572: INTO ln_affl_asg_act
573: FROM dual;
574:
575: hr_utility_trace('Creating affiliation report assignment action '||

Line 672: pay_assignment_actions paa_mag,

668:
669: CURSOR csr_prev_idw(cp_gre_token VARCHAR2) IS
670: SELECT fnd_number.canonical_to_number(pai.action_information8)
671: FROM pay_payroll_actions ppa_mag,
672: pay_assignment_actions paa_mag,
673: --pay_assignment_actions paa_arch,
674: pay_action_interlocks lck,
675: pay_action_information pai
676: WHERE ppa_mag.payroll_action_id = paa_mag.payroll_action_id

Line 673: --pay_assignment_actions paa_arch,

669: CURSOR csr_prev_idw(cp_gre_token VARCHAR2) IS
670: SELECT fnd_number.canonical_to_number(pai.action_information8)
671: FROM pay_payroll_actions ppa_mag,
672: pay_assignment_actions paa_mag,
673: --pay_assignment_actions paa_arch,
674: pay_action_interlocks lck,
675: pay_action_information pai
676: WHERE ppa_mag.payroll_action_id = paa_mag.payroll_action_id
677: AND paa_mag.assignment_action_id = lck.locking_action_id

Line 834: pay_assignment_actions paa_arch,

830: fnd_number.canonical_to_number(pai.action_information11), -- IDW
831: pai.action_information18 -- Salary Type
832: -- Bug 6065124
833: FROM pay_action_information pai /*,
834: pay_assignment_actions paa_arch,
835: pay_action_interlocks lck*/
836: WHERE pai.action_information_category = 'MX SS PERSON INFORMATION'
837: /*and lck.locking_action_id = cp_assignment_action_id
838: AND lck.locked_action_id = pai.action_context_id*/

Line 858: pay_assignment_actions paa,

854: fnd_date.canonical_to_date(
855: pay_mx_utility.get_legi_param_val('END_DATE',
856: ppa.legislative_parameters))
857: FROM pay_payroll_actions ppa,
858: pay_assignment_actions paa,
859: pay_action_information pai,
860: pay_action_interlocks lck
861: WHERE paa.payroll_action_id = ppa.payroll_action_id
862: AND paa.assignment_action_id = lck.locking_action_id

Line 912: pay_assignment_actions paa

908:
909: CURSOR csr_person (cp_assignment_action_id number) IS
910: SELECT paf.person_id
911: FROM per_assignments_f paf,
912: pay_assignment_actions paa
913: WHERE paa.assignment_action_id = cp_assignment_action_id
914: AND paa.assignment_id = paf.assignment_id;
915:
916: CURSOR csr_transactions (cp_assignment_action_id number,cp_imp_date varchar2) IS

Line 947: pay_assignment_actions paa_affl,

943: fnd_date.canonical_to_date (g_start_date)
944: AND fnd_date.canonical_to_date (g_end_date)
945: /*NOT EXISTS (SELECT 'X'
946: FROM pay_payroll_actions ppa_affl,
947: pay_assignment_actions paa_affl,
948: pay_action_interlocks lck
949: WHERE lck.locked_action_id = pai.action_context_id
950: AND lck.locking_action_id = paa_affl.assignment_action_id
951: AND paa_affl.payroll_action_id = ppa_affl.payroll_action_id

Line 1205: pay_assignment_actions paa_affl,

1201: CURSOR csr_employer IS
1202: SELECT pai.action_information_id
1203: FROM pay_action_information pai,
1204: pay_action_interlocks lck,
1205: pay_assignment_actions paa_affl,
1206: pay_assignment_actions paa_arch
1207: WHERE paa_affl.payroll_action_id =
1208: pay_magtape_generic.get_parameter_value ('PAYROLL_ACTION_ID')
1209: AND lck.locking_action_id = paa_affl.assignment_action_id

Line 1206: pay_assignment_actions paa_arch

1202: SELECT pai.action_information_id
1203: FROM pay_action_information pai,
1204: pay_action_interlocks lck,
1205: pay_assignment_actions paa_affl,
1206: pay_assignment_actions paa_arch
1207: WHERE paa_affl.payroll_action_id =
1208: pay_magtape_generic.get_parameter_value ('PAYROLL_ACTION_ID')
1209: AND lck.locking_action_id = paa_affl.assignment_action_id
1210: AND paa_arch.assignment_action_id = lck.locked_action_id