APPS.PAY_GB_P11D_ARCHIVE_SS dependencies on PAY_PAYROLL_ACTIONS

Line 173: FROM pay_payroll_actions

169: 0, DECODE(INSTR(legislative_parameters, p_token), 0, .5, LENGTH(legislative_parameters) ),
170: INSTR(legislative_parameters, ' ', INSTR(legislative_parameters, p_token) )
171: - (INSTR(legislative_parameters, p_token) + (LENGTH(p_token) + 1) ) ) ) ),
172: business_group_id, start_date, effective_date -- this will be the benefit end date
173: FROM pay_payroll_actions
174: WHERE payroll_action_id = p_pact_id;
175:
176: l_business_group_id VARCHAR2(20);
177: l_benefit_start_date VARCHAR2(20);

Line 492: pay_payroll_actions ppa

488: if l_person_id is not null then
489: sqlstr :=
490: 'SELECT DISTINCT person_id
491: FROM per_people_f ppf,
492: pay_payroll_actions ppa
493: WHERE ppa.payroll_action_id = :payroll_action_id
494: AND ppa.business_group_id +0= ppf.business_group_id
495: AND ppf.person_id = ' || l_person_id || ' ORDER BY ppf.person_id';
496: else

Line 500: pay_payroll_actions ppa

496: else
497: sqlstr :=
498: 'SELECT DISTINCT person_id
499: FROM per_people_f ppf,
500: pay_payroll_actions ppa
501: WHERE ppa.payroll_action_id = :payroll_action_id
502: AND ppa.business_group_id +0= ppf.business_group_id
503: ORDER BY ppf.person_id';
504: end if;

Line 523: l_leg_param pay_payroll_actions.legislative_parameters%type;

519: l_assignment_set_id NUMBER;
520: l_flex_id NUMBER;
521: l_proc CONSTANT VARCHAR2(50) := g_package || 'action_creation';
522: l_prev_assignment_id NUMBER(10) := NULL;
523: l_leg_param pay_payroll_actions.legislative_parameters%type;
524: l_count NUMBER;
525: l_set_payroll_id NUMBER;
526: l_archive BOOLEAN;
527: l_set_type VARCHAR2(2);

Line 773: from pay_payroll_actions

769: business_group_id,
770: fnd_date.date_to_canonical(start_date),
771: fnd_date.date_to_canonical(effective_date)
772: into l_leg_param, l_business_group_id, l_benefit_start_date, l_benefit_end_date
773: from pay_payroll_actions
774: where payroll_action_id = pactid;
775:
776: l_payroll_id := get_param_value('PAYROLL');
777: l_person_id := get_param_value('PERSON');

Line 1030: pay_payroll_actions ppa

1026: pai_comp.action_information7
1027: FROM pay_action_information pai_comp,
1028: pay_action_information pai_person,
1029: pay_assignment_actions paa,
1030: pay_payroll_actions ppa
1031: WHERE ppa.payroll_action_id = g_pactid
1032: AND paa.payroll_action_id = ppa.payroll_action_id
1033: AND pai_comp.action_context_id = paa.assignment_action_id
1034: AND pai_comp.action_information_category = 'EMEA PAYROLL INFO'

Line 3731: FROM pay_payroll_actions ppa,

3727: l_counter number;
3728: -- 4248907 Perf fix - csr_incorrect_ni_percentage - Broken into 2 separate cursors
3729: CURSOR csr_incorrect_ni_num IS
3730: SELECT pai.action_information7 action_information7, COUNT(1) temp_num
3731: FROM pay_payroll_actions ppa,
3732: pay_assignment_actions paa,
3733: pay_action_information pai,
3734: pay_action_information pai_emp
3735: WHERE ppa.payroll_action_id = pactid

Line 3750: FROM pay_payroll_actions ppa,

3746: GROUP BY pai.action_information7;
3747:
3748: CURSOR csr_total_num(p_employer_name varchar2) IS
3749: SELECT pai.action_information7 action_information7, COUNT(1) tot_num
3750: FROM pay_payroll_actions ppa,
3751: pay_assignment_actions paa,
3752: pay_action_information pai
3753: WHERE ppa.payroll_action_id = pactid
3754: AND paa.payroll_action_id = ppa.payroll_action_id

Line 3764: FROM pay_payroll_actions ppa,

3760:
3761: CURSOR csr_expenses_payment_chk
3762: IS
3763: SELECT COUNT(DISTINCT pai_ben.action_information10)
3764: FROM pay_payroll_actions ppa,
3765: pay_assignment_actions paa,
3766: pay_action_information pai_ben
3767: WHERE ppa.payroll_action_id = pactid
3768: AND ppa.payroll_action_id = paa .payroll_action_id

Line 3795: pay_payroll_actions ppa

3791: '0') ) p11db_value
3792: FROM pay_action_information pai_comp,
3793: pay_action_information pai,
3794: pay_assignment_actions paa,
3795: pay_payroll_actions ppa
3796: WHERE ppa.payroll_action_id = pactid
3797: AND ppa.payroll_action_id = paa .payroll_action_id
3798: AND pai_comp.action_context_id = paa.assignment_action_id
3799: AND pai_comp.action_information_category = 'EMEA PAYROLL INFO'

Line 4210: from pay_payroll_actions pay,

4206: pml.message_level,
4207: substr(pml.line_text,instr(pml.line_text,':') + 2) line_text,
4208: substr(pml.line_text,6,instr(pml.line_text,':') - 6) element_name,
4209: pml.line_sequence
4210: from pay_payroll_actions pay,
4211: pay_assignment_actions paa,
4212: per_all_assignments_f paf,
4213: per_all_people_f pap,
4214: per_periods_of_service pos,