APPS.PER_NL_FDR_ARCHIVE dependencies on DUAL

Line 365: (select p_org_id from dual))

361: WHERE pose.org_structure_version_id = posv.org_structure_version_id
362: START with pose.organization_id_parent = p_org_id
363: CONNECT BY prior organization_id_child = organization_id_parent)
364: UNION
365: (select p_org_id from dual))
366: OR
367: nvl(paa.establishment_id,-1) = p_org_id)
368: and paa.person_id = p_person_id
369: and paa.primary_flag = 'Y'

Line 646: sqlstr := 'select 1 from dual where to_char(:payroll_action_id) = dummy';

642: EXCEPTION
643:
644: WHEN OTHERS THEN
645: -- Return cursor that selects no rows
646: sqlstr := 'select 1 from dual where to_char(:payroll_action_id) = dummy';
647:
648:
649: END RANGE_CODE;
650:

Line 734: (select p_org_id from dual))

730: WHERE pose.org_structure_version_id = posv.org_structure_version_id
731: START with pose.organization_id_parent = p_org_id
732: CONNECT BY prior organization_id_child = organization_id_parent)
733: UNION
734: (select p_org_id from dual))
735: OR
736: nvl(paa.establishment_id,-1) = p_org_id
737: )
738: and paa.person_id = pap.person_id

Line 853: FROM dual;

849: LOOP
850:
851: SELECT pay_assignment_actions_s.NEXTVAL
852: INTO l_asg_act_id
853: FROM dual;
854:
855: hr_nonrun_asact.insact(l_asg_act_id,v_csr_get_asg_person.assignment_id, p_payroll_action_id,p_chunk,NULL);
856:
857: --hr_utility.set_location('Assignment id - '||to_char(v_csr_get_asg_person.assignment_id)||' selected',45);

Line 873: FROM dual;

869: --hr_utility.set_location('Selecting assignment '||to_char(v_csr_get_asg_org.assignment_id),55);
870:
871: SELECT pay_assignment_actions_s.NEXTVAL
872: INTO l_asg_act_id
873: FROM dual;
874:
875: hr_nonrun_asact.insact(l_asg_act_id,v_csr_get_asg_org.assignment_id, p_payroll_action_id,p_chunk,NULL);
876:
877: --hr_utility.set_location('Assignment id - '||to_char(v_csr_get_asg_org.assignment_id)||' selected',57);

Line 895: FROM dual;

891: --hr_utility.set_location('Assignment id - '||to_char(v_csr_get_asg_hier.assignment_id)||' selected before inserting', 62);
892:
893: SELECT pay_assignment_actions_s.NEXTVAL
894: INTO l_asg_act_id
895: FROM dual;
896:
897: hr_nonrun_asact.insact(l_asg_act_id,v_csr_get_asg_hier.assignment_id, p_payroll_action_id,p_chunk,NULL);
898:
899: --hr_utility.set_location('Assignment id - '||to_char(v_csr_get_asg_hier.assignment_id)||' inserted', 65);