DBA Data[Home] [Help]

APPS.PAY_SG_CPFLINE dependencies on FND_DATE

Line 126: and g_pact.start_date between nvl(fnd_date.canonical_to_date(aei1.aei_information2(+)),to_date('01/01/1900','DD/MM/YYYY')) and nvl(fnd_date.canonical_to_date(aei1.aei_information3(+)),to_date('31/12/4712','DD/MM/YYYY'))

122: and substr(aei2.aei_information1(+),11,3)='VCT'
123: and (hoi.org_information10=g_pact.csn
124: or aei1.aei_information1=g_pact.csn
125: or aei2.aei_information1=g_pact.csn)
126: and g_pact.start_date between nvl(fnd_date.canonical_to_date(aei1.aei_information2(+)),to_date('01/01/1900','DD/MM/YYYY')) and nvl(fnd_date.canonical_to_date(aei1.aei_information3(+)),to_date('31/12/4712','DD/MM/YYYY'))
127: and g_pact.start_date between nvl(fnd_date.canonical_to_date(aei2.aei_information2(+)),to_date('01/01/1900','DD/MM/YYYY')) and nvl(fnd_date.canonical_to_date(aei2.aei_information3(+)),to_date('31/12/4712','DD/MM/YYYY'));
128: --
129: cursor next_action_id
130: is

Line 127: and g_pact.start_date between nvl(fnd_date.canonical_to_date(aei2.aei_information2(+)),to_date('01/01/1900','DD/MM/YYYY')) and nvl(fnd_date.canonical_to_date(aei2.aei_information3(+)),to_date('31/12/4712','DD/MM/YYYY'));

123: and (hoi.org_information10=g_pact.csn
124: or aei1.aei_information1=g_pact.csn
125: or aei2.aei_information1=g_pact.csn)
126: and g_pact.start_date between nvl(fnd_date.canonical_to_date(aei1.aei_information2(+)),to_date('01/01/1900','DD/MM/YYYY')) and nvl(fnd_date.canonical_to_date(aei1.aei_information3(+)),to_date('31/12/4712','DD/MM/YYYY'))
127: and g_pact.start_date between nvl(fnd_date.canonical_to_date(aei2.aei_information2(+)),to_date('01/01/1900','DD/MM/YYYY')) and nvl(fnd_date.canonical_to_date(aei2.aei_information3(+)),to_date('31/12/4712','DD/MM/YYYY'));
128: --
129: cursor next_action_id
130: is
131: select pay_assignment_actions_s.nextval

Line 253: fnd_date.date_to_canonical(pps.actual_termination_date),

249: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type )
250: is
251: select substr(pap.per_information1,1,22),
252: substr(pap.employee_number,1,15),
253: fnd_date.date_to_canonical(pps.actual_termination_date),
254: decode(g_pact.month_date,to_char(pap.start_date,'YYYYMM'),'NEW','EE') emp_status,
255: rpac.assignment_action_id,
256: fnd_date.date_to_canonical(rppa.effective_date),
257: pap.per_information6,

Line 256: fnd_date.date_to_canonical(rppa.effective_date),

252: substr(pap.employee_number,1,15),
253: fnd_date.date_to_canonical(pps.actual_termination_date),
254: decode(g_pact.month_date,to_char(pap.start_date,'YYYYMM'),'NEW','EE') emp_status,
255: rpac.assignment_action_id,
256: fnd_date.date_to_canonical(rppa.effective_date),
257: pap.per_information6,
258: substr(hou.name,1,80),
259: nvl(pap.per_information14,pap.national_identifier),
260: fnd_date.date_to_canonical(pps.date_start),

Line 260: fnd_date.date_to_canonical(pps.date_start),

256: fnd_date.date_to_canonical(rppa.effective_date),
257: pap.per_information6,
258: substr(hou.name,1,80),
259: nvl(pap.per_information14,pap.national_identifier),
260: fnd_date.date_to_canonical(pps.date_start),
261: pap.person_id,
262: fnd_date.date_to_canonical(paa.effective_start_date),
263: nvl(aei1.aei_information1,hoi.org_information10),
264: aei2.aei_information1

Line 262: fnd_date.date_to_canonical(paa.effective_start_date),

258: substr(hou.name,1,80),
259: nvl(pap.per_information14,pap.national_identifier),
260: fnd_date.date_to_canonical(pps.date_start),
261: pap.person_id,
262: fnd_date.date_to_canonical(paa.effective_start_date),
263: nvl(aei1.aei_information1,hoi.org_information10),
264: aei2.aei_information1
265: from pay_assignment_actions pac,
266: pay_payroll_actions rppa,

Line 302: and g_pact.start_date between nvl(fnd_date.canonical_to_date(aei1.aei_information2(+)),to_date('01/01/1900','DD/MM/YYYY')) and nvl(fnd_date.canonical_to_date(aei1.aei_information3(+)),to_date('31/12/4712','DD/MM/YYYY'))

298: and substr(aei2.aei_information1(+),11,3)='VCT'
299: and (hoi.org_information10=g_pact.csn
300: or aei1.aei_information1=g_pact.csn
301: or aei2.aei_information1=g_pact.csn)
302: and g_pact.start_date between nvl(fnd_date.canonical_to_date(aei1.aei_information2(+)),to_date('01/01/1900','DD/MM/YYYY')) and nvl(fnd_date.canonical_to_date(aei1.aei_information3(+)),to_date('31/12/4712','DD/MM/YYYY'))
303: and g_pact.start_date between nvl(fnd_date.canonical_to_date(aei2.aei_information2(+)),to_date('01/01/1900','DD/MM/YYYY')) and nvl(fnd_date.canonical_to_date(aei2.aei_information3(+)),to_date('31/12/4712','DD/MM/YYYY'))
304: order by rppa.action_sequence desc;
305:
306: begin

Line 303: and g_pact.start_date between nvl(fnd_date.canonical_to_date(aei2.aei_information2(+)),to_date('01/01/1900','DD/MM/YYYY')) and nvl(fnd_date.canonical_to_date(aei2.aei_information3(+)),to_date('31/12/4712','DD/MM/YYYY'))

299: and (hoi.org_information10=g_pact.csn
300: or aei1.aei_information1=g_pact.csn
301: or aei2.aei_information1=g_pact.csn)
302: and g_pact.start_date between nvl(fnd_date.canonical_to_date(aei1.aei_information2(+)),to_date('01/01/1900','DD/MM/YYYY')) and nvl(fnd_date.canonical_to_date(aei1.aei_information3(+)),to_date('31/12/4712','DD/MM/YYYY'))
303: and g_pact.start_date between nvl(fnd_date.canonical_to_date(aei2.aei_information2(+)),to_date('01/01/1900','DD/MM/YYYY')) and nvl(fnd_date.canonical_to_date(aei2.aei_information3(+)),to_date('31/12/4712','DD/MM/YYYY'))
304: order by rppa.action_sequence desc;
305:
306: begin
307: l_package := ' pay_sg_cpfline.';

Line 463: fnd_date.canonical_to_date(rec_action_info.action_information20),

459: values (
460: pay_action_information_s.nextval,
461: p_assignment_action_id,
462: 'AAC',
463: fnd_date.canonical_to_date(rec_action_info.action_information20),
464: l_person_id,
465: g_pact.legal_entity_id,
466: 'SG CPF DETAILS',
467: rec_action_info.action_information1,