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 774: from pay_payroll_actions

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

Line 1031: pay_payroll_actions ppa

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

Line 3797: FROM pay_payroll_actions ppa,

3793: l_counter number;
3794: -- 4248907 Perf fix - csr_incorrect_ni_percentage - Broken into 2 separate cursors
3795: CURSOR csr_incorrect_ni_num IS
3796: SELECT pai.action_information7 action_information7, COUNT(1) temp_num
3797: FROM pay_payroll_actions ppa,
3798: pay_assignment_actions paa,
3799: pay_action_information pai,
3800: pay_action_information pai_emp
3801: WHERE ppa.payroll_action_id = pactid

Line 3816: FROM pay_payroll_actions ppa,

3812: GROUP BY pai.action_information7;
3813:
3814: CURSOR csr_total_num(p_employer_name varchar2) IS
3815: SELECT pai.action_information7 action_information7, COUNT(1) tot_num
3816: FROM pay_payroll_actions ppa,
3817: pay_assignment_actions paa,
3818: pay_action_information pai
3819: WHERE ppa.payroll_action_id = pactid
3820: AND paa.payroll_action_id = ppa.payroll_action_id

Line 3830: FROM pay_payroll_actions ppa,

3826:
3827: CURSOR csr_expenses_payment_chk
3828: IS
3829: SELECT COUNT(DISTINCT pai_ben.action_information10)
3830: FROM pay_payroll_actions ppa,
3831: pay_assignment_actions paa,
3832: pay_action_information pai_ben
3833: WHERE ppa.payroll_action_id = pactid
3834: AND ppa.payroll_action_id = paa .payroll_action_id

Line 3861: pay_payroll_actions ppa

3857: '0') ) p11db_value
3858: FROM pay_action_information pai_comp,
3859: pay_action_information pai,
3860: pay_assignment_actions paa,
3861: pay_payroll_actions ppa
3862: WHERE ppa.payroll_action_id = pactid
3863: AND ppa.payroll_action_id = paa .payroll_action_id
3864: AND pai_comp.action_context_id = paa.assignment_action_id
3865: AND pai_comp.action_information_category = 'EMEA PAYROLL INFO'

Line 4330: from pay_payroll_actions pay,

4326: pml.message_level,
4327: substr(pml.line_text,instr(pml.line_text,':') + 2) line_text,
4328: substr(pml.line_text,6,instr(pml.line_text,':') - 6) element_name,
4329: pml.line_sequence
4330: from pay_payroll_actions pay,
4331: pay_assignment_actions paa,
4332: per_all_assignments_f paf,
4333: per_all_people_f pap,
4334: per_periods_of_service pos,