APPS.PER_MX_SS_AFFILIATION dependencies on PAY_PAYROLL_ACTIONS

Line 180: FROM pay_payroll_actions

176: P_TRANS_GRE number
177: ) RETURN VARCHAR2 AS
178: CURSOR csr_get_date_dispmag IS
179: SELECT fnd_date.date_to_canonical (effective_date + 1/(24 * 60 * 60))
180: FROM pay_payroll_actions
181: WHERE report_type = 'SS_AFFILIATION'
182: AND report_qualifier IN ('HIRES', 'SEPARATIONS', 'SALARY')
183: AND pay_mx_utility.get_legi_param_val('TRANS_GRE',
184: legislative_parameters,

Line 195: FROM pay_payroll_actions

191: fnd_date.canonical_to_date(
192: pay_mx_utility.get_legi_param_val('END_DATE',
193: legislative_parameters)) +
194: 1/(24 * 60 * 60))
195: FROM pay_payroll_actions
196: WHERE report_type = 'MX_SS_AFFL'
197: AND report_qualifier = 'MX_SS_AFFL'
198: AND pay_mx_utility.get_legi_param_val('TRANS_GRE',
199: legislative_parameters) =

Line 278: FROM pay_payroll_actions ppa

274: ppa.legislative_parameters),
275: pay_mx_utility.get_legi_param_val('END_DATE',
276: ppa.legislative_parameters),
277: business_group_id
278: FROM pay_payroll_actions ppa
279: WHERE ppa.payroll_action_id = p_payroll_action_id;
280:
281: CURSOR csr_gre IS
282: SELECT organization_id

Line 459: FROM pay_payroll_actions ppa_affl,

455: fnd_date.canonical_to_date (g_start_date)
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

Line 515: FROM pay_payroll_actions ppa_affl,

511: trunc(fnd_date.canonical_to_date (g_start_date))
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

Line 555: FROM pay_payroll_actions pact,

551: Affiliation report*/
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

Line 778: FROM pay_payroll_actions ppa_mag,

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

Line 1007: FROM pay_payroll_actions ppa,

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

Line 1101: FROM pay_payroll_actions ppa_affl,

1097: fnd_date.canonical_to_date (g_start_date)
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