APPS.PQP_US_STUDENT_EARNINGS dependencies on FND_DATE

Line 247: ,fnd_date.canonical_to_date(p_begin_date_paid)

243: and upper(hasa.include_or_exclude) = ''I'')';
244:
245: open pri_cur for l_selcrs
246: using to_number(p_business_group_id)
247: ,fnd_date.canonical_to_date(p_begin_date_paid)
248: ,fnd_date.canonical_to_date(p_end_date_paid)
249: ,to_number(p_element_type_id)
250: ,to_number(p_assignment_set);
251: else

Line 248: ,fnd_date.canonical_to_date(p_end_date_paid)

244:
245: open pri_cur for l_selcrs
246: using to_number(p_business_group_id)
247: ,fnd_date.canonical_to_date(p_begin_date_paid)
248: ,fnd_date.canonical_to_date(p_end_date_paid)
249: ,to_number(p_element_type_id)
250: ,to_number(p_assignment_set);
251: else
252: l_selcrs :=

Line 300: ,fnd_date.canonical_to_date(p_begin_date_paid)

296: and upper(hasa.include_or_exclude) = ''I'')';
297:
298: open pri_cur for l_selcrs
299: using to_number(p_business_group_id)
300: ,fnd_date.canonical_to_date(p_begin_date_paid)
301: ,fnd_date.canonical_to_date(p_end_date_paid)
302: ,to_number(p_element_set_id)
303: ,to_number(p_element_set_id)
304: ,to_number(p_element_set_id)

Line 301: ,fnd_date.canonical_to_date(p_end_date_paid)

297:
298: open pri_cur for l_selcrs
299: using to_number(p_business_group_id)
300: ,fnd_date.canonical_to_date(p_begin_date_paid)
301: ,fnd_date.canonical_to_date(p_end_date_paid)
302: ,to_number(p_element_set_id)
303: ,to_number(p_element_set_id)
304: ,to_number(p_element_set_id)
305: ,to_number(p_assignment_set);

Line 358: between '||''''|| fnd_date.canonical_to_date(p_begin_date_paid) ||''''|| '

354: and ppa.business_group_id = ' || p_business_group_id || '
355: and ppa.action_type in
356: (''Q'',''B'',''V'',''R'',''O'',''G'',''L'')
357: and ppa.date_earned
358: between '||''''|| fnd_date.canonical_to_date(p_begin_date_paid) ||''''|| '
359: and '||''''|| fnd_date.canonical_to_date(p_end_date_paid) ||''''|| '
360: and prr.assignment_action_id = paa.assignment_action_id
361: and prr.status in (''P'',''PA'')
362: and prr.element_type_id = '|| p_element_type_id ||'

Line 359: and '||''''|| fnd_date.canonical_to_date(p_end_date_paid) ||''''|| '

355: and ppa.action_type in
356: (''Q'',''B'',''V'',''R'',''O'',''G'',''L'')
357: and ppa.date_earned
358: between '||''''|| fnd_date.canonical_to_date(p_begin_date_paid) ||''''|| '
359: and '||''''|| fnd_date.canonical_to_date(p_end_date_paid) ||''''|| '
360: and prr.assignment_action_id = paa.assignment_action_id
361: and prr.status in (''P'',''PA'')
362: and prr.element_type_id = '|| p_element_type_id ||'
363: and exists

Line 402: between '||''''|| fnd_date.canonical_to_date(p_begin_date_paid) ||''''|| '

398: and ppa.business_group_id = ' || p_business_group_id || '
399: and ppa.action_type in
400: (''Q'',''B'',''V'',''R'',''O'',''G'',''L'')
401: and ppa.date_earned
402: between '||''''|| fnd_date.canonical_to_date(p_begin_date_paid) ||''''|| '
403: and '||''''|| fnd_date.canonical_to_date(p_end_date_paid) ||''''|| '
404: and prr.assignment_action_id = paa.assignment_action_id
405: and prr.status IN (''P'',''PA'')
406: and prr.element_type_id in

Line 403: and '||''''|| fnd_date.canonical_to_date(p_end_date_paid) ||''''|| '

399: and ppa.action_type in
400: (''Q'',''B'',''V'',''R'',''O'',''G'',''L'')
401: and ppa.date_earned
402: between '||''''|| fnd_date.canonical_to_date(p_begin_date_paid) ||''''|| '
403: and '||''''|| fnd_date.canonical_to_date(p_end_date_paid) ||''''|| '
404: and prr.assignment_action_id = paa.assignment_action_id
405: and prr.status IN (''P'',''PA'')
406: and prr.element_type_id in
407: (select distinct petr.element_type_id

Line 482: ,fnd_date.canonical_to_date(p_begin_date_paid)

478: and paf.assignment_id = paa.assignment_id)';
479:
480: open pri_cur for l_selcrs
481: using to_number(p_business_group_id)
482: ,fnd_date.canonical_to_date(p_begin_date_paid)
483: ,fnd_date.canonical_to_date(p_end_date_paid)
484: ,to_number(p_element_type_id);
485: else
486: l_selcrs :=

Line 483: ,fnd_date.canonical_to_date(p_end_date_paid)

479:
480: open pri_cur for l_selcrs
481: using to_number(p_business_group_id)
482: ,fnd_date.canonical_to_date(p_begin_date_paid)
483: ,fnd_date.canonical_to_date(p_end_date_paid)
484: ,to_number(p_element_type_id);
485: else
486: l_selcrs :=
487: 'select paa.assignment_id

Line 534: ,fnd_date.canonical_to_date(p_begin_date_paid)

530: and pei.information_type = ''PQP_OSS_PERSON_DETAILS''
531: and paf.assignment_id = paa.assignment_id)';
532: open pri_cur for l_selcrs
533: using to_number(p_business_group_id)
534: ,fnd_date.canonical_to_date(p_begin_date_paid)
535: ,fnd_date.canonical_to_date(p_end_date_paid)
536: ,to_number(p_element_set_id)
537: ,to_number(p_element_set_id)
538: ,to_number(p_element_set_id);

Line 535: ,fnd_date.canonical_to_date(p_end_date_paid)

531: and paf.assignment_id = paa.assignment_id)';
532: open pri_cur for l_selcrs
533: using to_number(p_business_group_id)
534: ,fnd_date.canonical_to_date(p_begin_date_paid)
535: ,fnd_date.canonical_to_date(p_end_date_paid)
536: ,to_number(p_element_set_id)
537: ,to_number(p_element_set_id)
538: ,to_number(p_element_set_id);
539: end if;--if p_element_selection

Line 586: ,fnd_date.canonical_to_date(p_begin_date_paid)

582: and per.business_group_id = :6 )';
583:
584: open pri_cur for l_selcrs
585: using to_number(p_business_group_id)
586: ,fnd_date.canonical_to_date(p_begin_date_paid)
587: ,fnd_date.canonical_to_date(p_end_date_paid)
588: ,to_number(p_element_type_id)
589: ,p_ssn
590: ,to_number(p_business_group_id);

Line 587: ,fnd_date.canonical_to_date(p_end_date_paid)

583:
584: open pri_cur for l_selcrs
585: using to_number(p_business_group_id)
586: ,fnd_date.canonical_to_date(p_begin_date_paid)
587: ,fnd_date.canonical_to_date(p_end_date_paid)
588: ,to_number(p_element_type_id)
589: ,p_ssn
590: ,to_number(p_business_group_id);
591: else

Line 652: ,fnd_date.canonical_to_date(p_begin_date_paid)

648: )';
649:
650: open pri_cur for l_selcrs
651: using to_number(p_business_group_id)
652: ,fnd_date.canonical_to_date(p_begin_date_paid)
653: ,fnd_date.canonical_to_date(p_end_date_paid)
654: ,to_number(p_element_set_id)
655: ,to_number(p_element_set_id)
656: ,to_number(p_element_set_id)

Line 653: ,fnd_date.canonical_to_date(p_end_date_paid)

649:
650: open pri_cur for l_selcrs
651: using to_number(p_business_group_id)
652: ,fnd_date.canonical_to_date(p_begin_date_paid)
653: ,fnd_date.canonical_to_date(p_end_date_paid)
654: ,to_number(p_element_set_id)
655: ,to_number(p_element_set_id)
656: ,to_number(p_element_set_id)
657: ,p_ssn