APPS.PER_MX_SS_AFFILIATION dependencies on PAY_PAYROLL_ACTIONS

Line 161: FROM pay_payroll_actions

157: P_TRANS_GRE number
158: ) RETURN VARCHAR2 AS
159: CURSOR csr_get_date_dispmag IS
160: SELECT fnd_date.date_to_canonical (effective_date + 1/(24 * 60 * 60))
161: FROM pay_payroll_actions
162: WHERE report_type = 'SS_AFFILIATION'
163: AND report_qualifier IN ('HIRES', 'SEPARATIONS', 'SALARY')
164: AND pay_mx_utility.get_legi_param_val('TRANS_GRE',
165: legislative_parameters,

Line 176: FROM pay_payroll_actions

172: fnd_date.canonical_to_date(
173: pay_mx_utility.get_legi_param_val('END_DATE',
174: legislative_parameters)) +
175: 1/(24 * 60 * 60))
176: FROM pay_payroll_actions
177: WHERE report_type = 'MX_SS_AFFL'
178: AND report_qualifier = 'MX_SS_AFFL'
179: AND pay_mx_utility.get_legi_param_val('TRANS_GRE',
180: legislative_parameters) =

Line 259: FROM pay_payroll_actions ppa

255: ppa.legislative_parameters),
256: pay_mx_utility.get_legi_param_val('END_DATE',
257: ppa.legislative_parameters),
258: business_group_id
259: FROM pay_payroll_actions ppa
260: WHERE ppa.payroll_action_id = p_payroll_action_id;
261:
262: CURSOR csr_gre IS
263: SELECT organization_id

Line 426: FROM pay_payroll_actions ppa_affl,

422: OR (pai.effective_date BETWEEN
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

Line 478: FROM pay_payroll_actions ppa_affl,

474: OR (pai.effective_date BETWEEN
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

Line 671: FROM pay_payroll_actions ppa_mag,

667: ) AS
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

Line 857: FROM pay_payroll_actions ppa,

853: SELECT paa.assignment_action_id,
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

Line 946: FROM pay_payroll_actions ppa_affl,

942: OR (pai.effective_date BETWEEN
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